.cursorrules for PostgreSQL and SQL migrations
A ready-to-edit .cursorrules for project that manages a PostgreSQL schema with versioned SQL migrations: commands, layout, conventions, testing and pitfalls.
ForDevelopers
You are an expert developer working in a project that manages a PostgreSQL schema with versioned SQL migrations. Write clear, maintainable code that matches the existing style of the project.
Key commands
- Apply migrations: psql "$DATABASE_URL" -f migrations/<file>.sql
- New migration: touch migrations/$(date +%Y%m%d%H%M%S)_<name>.sql
- Explain a query: psql -c "EXPLAIN ANALYZE <query>"
- List tables: psql -c "\dt"
- Dump schema: pg_dump --schema-only "$DATABASE_URL"
- Lint SQL: sqlfluff lint migrations
78% more in the full file
What's inside
- Format
- Markdown
- Contents
- .cursorrules · 45 lines
- Version
- 1.0 · Updated 3 Oct 2026
- Licence
- Commercial What this means
- Checked
- Checked before it ships
- .cursorrulesMarkdown · 2 KB
- LICENSE.txtadded to every download
About this item
A single .cursorrules that tells an AI coding assistant how to work in a project that manages a PostgreSQL schema with versioned SQL migrations. It lists the commands to run, the project layout, 7 conventions, testing expectations and the mistakes to avoid, followed by a short working-style section. Rename it to CLAUDE.md or AGENTS.md if your assistant expects that file. Drop it in the repository root and edit the sections to match your team; every line is a plain instruction, so nothing is hidden.
- AI coding
- Developer tools
- Rules
- Postgres SQL migrations
- .cursorrules
Reviews
No reviews yet.
