Generate PostgreSQL SQL queries from database schemas and application code.
npx skills add https://github.com/octkp/dotfiles --skill sql-generator
Please help me install this Agent Skill. Skill: sql-generator Source: https://github.com/octkp/dotfiles/tree/main/claude/skills/sql-generator Command: npx skills add https://github.com/octkp/dotfiles --skill sql-generator
DB-driven applications often require precise SQL queries that reflect evolving schemas and codebases. This skill analyzes database schemas and application code to generate PostgreSQL-compatible SQL queries that exactly meet user requests such as retrieving specific data, updating records, or generating reports.
Generate a PostgreSQL query that lists all users activated in the last 30 days.
High-intent search queries and answers about installing and using this skill.
Generate PostgreSQL queries by analyzing your database schema and application code to produce SQL statements that match user requests. This approach ensures the generated queries reflect evolving schemas and enforce PostgreSQL-specific syntax with explicit column listing.
Yes, you can generate SQL aggregate queries with proper JOINs across multiple PostgreSQL tables. The process supports SELECT, INSERT, UPDATE, and DELETE operations, applying constraints to retrieve, update, or aggregate data for tasks like generating sales reports.
Yes, this SQL query generation approach is designed for PostgreSQL projects specifically. It enforces PostgreSQL-specific syntax and explicit column listing, ensuring the generated queries comply with the target database system's requirements.
The best way to ensure generated SQL queries match an evolving schema is to derive them by analyzing both the database schema and the application code structure. This guarantees the SQL precisely satisfies the data retrieval or updating request.
Safe query generation handles validation and error checking by enforcing PostgreSQL-specific syntax and explicit column listing. This mechanism ensures the generated SQL queries are validated against the schema and codebase before execution.
You need to analyze application code to generate SQL when database-driven applications require precise queries reflecting evolving schemas and codebases. This is necessary for complex tasks like generating reports that aggregate data across multiple tables.
calevansDocument SQLite schema with table definitions, indexes, and SQL query patterns.
mkurmanQuery REST APIs across 78 public databases and aggregate JSON results with pagination and provenance.
zizzfizzixAutomate database schema migrations for ORM-based applications.
ano4lAutomate SQL queries, migrations, and ORM integration across multiple databases.
