write-postgres-sql
CommunityGenerate clean, fast PostgreSQL SQL end-to-end.
Authorly0o0o
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Generates correct, efficient, and safe PostgreSQL SQL queries tailored to data analysis, reporting, migrations, and optimization tasks, freeing users from manual SQL construction and error-prone drafting.
Core Features & Use Cases
- Stage 1 — understand_request: analyzes intent, schema, and filters to avoid mistakes.
- Stage 2 — generate_sql: logical planning including table/field selection, join relationships, and needed aggregations.
- Stage 3 — validate_sql: verifies syntax, avoids SELECT *, ensures WHERE clauses for large tables, and aligns with PostgreSQL conventions.
- Schema-driven: fetches actual schema from Prisma migrations or ORM models if not provided.
- Safety and guardrails: explicit JOINs, proper typing, and safeguards for write operations.
Quick Start
Describe your data schema and the query goal, and I will generate ready-to-run PostgreSQL SQL.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: write-postgres-sql Download link: https://github.com/ly0o0o/lyoo-ai-productivity/archive/main.zip#write-postgres-sql Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.