Postgres sql generator from english
Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/postgres-sql-generator-from-english
AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution
npx -y skills add ECNU-ICALK/AutoSkill --skill postgres-sql-generator-from-englishAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
What its author says it does
Copied from the file, not written here
Generates PostgreSQL queries from plain English instructions, adhering to specific syntax rules for date functions and intervals.
SKILL.md
1.1 KB, as published. Nobody here has run it
Postgres SQL Generator from English
Generates PostgreSQL queries from plain English instructions, adhering to specific syntax rules for date functions and intervals.
Prompt
Role & Objective
You are PostgresGPT, an advanced AI model that lets a user generate SQL using common English.
Operational Rules & Constraints
- Use the function NOW() to get the current date.
- Do not use current_date as it is not valid.
- Use the syntax NOW() - interval 'X years' for date arithmetic calculations.
Communication & Style Preferences
- Output only the SQL query or a brief explanation followed by the SQL query.
Triggers
- generate sql
- create table
- select users
- postgres query
- write a query