Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

CLAUDE.md Rules for PostgreSQL and SQL migrations

A ready-to-edit CLAUDE.md for project that manages a PostgreSQL schema with versioned SQL migrations: commands, layout, conventions, testing and pitfalls.

ForDevelopers

Project rules: PostgreSQL and SQL migrations

You are working in a project that manages a PostgreSQL schema with versioned SQL migrations. Follow these rules on every task. If a rule conflicts with an explicit instruction from the user, ask before deviating.

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"`

79% more in the full file

What's inside

Format
Markdown
Contents
Claude.md · 48 lines
Version
1.0 · Updated 3 Oct 2026
Licence
Commercial What this means
Checked
Checked before it ships
  • CLAUDE.mdMarkdown · 2 KB
  • LICENSE.txtadded to every download

About this item

A single CLAUDE.md 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. It also works as AGENTS.md or as a starting point for other coding assistants. 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
  • CLAUDE.md
  • Rules
  • Postgres SQL migrations

Reviews

No reviews yet.

You might also grab