Postgres schema, then queries - Agent Skills
SponsoredSkillry: Agent Skills with taste. Designed and tested in-house, so one prompt gives you polished slides, web pages and launch videos.Skillry: Agent Skills with taste Try free Skills
Agent Skills
  • Skills
  • Picks
  • ShopSoon
  • Solutions
  • Specification
  • Submit
Agent Skills
All picks

Scene picks

Postgres schema, then queries

Normalize first, then Postgres-specific types and indexes. Supabase notes only if you host there.

Table drawers with a key and a funnel pouring out rows

Why these

database-design is generic. postgresql-table-design is the one that will argue with you about types and indexes. Read them in that order or you will denormalize before you have a normal form to denormalize.

Install in this order

  1. 1database-design

    First. Keys, normalization, and the migration sequence. The examples are Postgres-flavored, but the decisions are the model.

  2. 2postgresql-table-design

    Second, once the entities exist. Types, constraints, and indexes for Postgres specifically.

  3. 3supabase-postgres-best-practices

    Only on Supabase. Skip it on RDS or a local Postgres. The advice assumes that platform.

  4. 4logging-best-practices

    After the tables exist. Wide events, so a slow query has a line you can find. Not a schema tool.

Not for this

Picking Nest or FastAPI. Use the API pick after this one. I did not execute the SQL from database-design on 2026-11-04: nothing was listening on the local Postgres socket.

Agent Skills

Discover and share powerful Agent Skills for AI assistants

GitHubX (Twitter)
Skills
  • View All
  • Install Guide
  • Documentation
  • Solutions
  • Product Launch Video
  • Submit
Tools
  • Claude Code
  • Cursor
  • OpenCode
  • Codex CLI
  • Gemini CLI
Resources
  • anthropics/skills
  • awesome-claude-skills
  • vercel-labs/agent-skills
  • kepano/obsidian-skills
Company
  • About
  • Changelog
  • Privacy Policy
  • Terms of Service

Sponsored by Vectrust @ OpenDev Org & NextRouter Alliance

© 2026 EvergreenAI. Built with JimmyLv