Postgres Engineering
Use when designing, changing, querying, securing, or diagnosing PostgreSQL databases; establish the real version and workload, prefer read-only evidence, and bound production effects before schema, index, maintenance, replication, or recovery actions.
Install
npx skills add sandbaseai/workbuddy-skill --skill postgres-engineeringgit clone --depth 1 https://github.com/sandbaseai/workbuddy-skill.git /tmp/workbuddy-skill
mkdir -p ~/.claude/skills
cp -r /tmp/workbuddy-skill/skills/postgres-engineering ~/.claude/skills/postgres-engineeringPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# PostgreSQL Database Engineering Use this skill for PostgreSQL-specific design and operations, whether hosted by Supabase or elsewhere. Establish the server and extension versions, hosting constraints, topology, workload, data sensitivity, and environment before relying on version-dependent features or executing commands. ## Inspect before changing Prefer migrations, schema files, application queries, and read-only catalog views as evidence. Confirm table grain, keys, constraints, data types, defaults, generated columns, partitions, indexes, row counts, growth, dependencies, RLS policies, roles, and ownership. Do not infer physical names or production state from an ORM alone. Use a least-privileged account and a non-production database or read replica when it answers the question. Redact credentials, connection strings, query parameters, personal data, and tenant identifiers. Before any production write, DDL, maintenance, role/policy, replication, failover, restore, or configuration action, require explicit authority for that operation and environment. ## Design schemas deliberately Choose types and constraints that encode the real domain: distinguish timestamps with and without time zone, use exact numeric types where rounding matters, and avoid an enum or extension when its migration and portability cost outweighs its value. Make primary, unique, foreign-key, check, and exclusion constraints match the intended invariant.
Details
- Skill name
postgres-engineering- Repository
- sandbaseai/workbuddy-skill
- Path
skills/postgres-engineering/SKILL.md- License
- MIT
- Repo updated
- 8 September 2026
FAQ
What does the Postgres Engineering skill do?
Use when designing, changing, querying, securing, or diagnosing PostgreSQL databases; establish the real version and workload, prefer read-only evidence, and bound production effects before schema, index, maintenance, replication, or recovery actions.
How do I install the Postgres Engineering skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add sandbaseai/workbuddy-skill --skill postgres-engineering. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Postgres Engineering popular?
It lives in sandbaseai/workbuddy-skill, which has 9 GitHub stars and 3 forks.
Related skills
Access Control Security Best Practices
9sandbaseai/workbuddy-skill
Design, review, implement, and verify least-privilege access controls across users, services, tenants, resources, and administrative workflows.
Accessibility Review
9sandbaseai/workbuddy-skill
Use when reviewing a web interface or interaction for semantic, keyboard, focus, screen-reader, ARIA, and contrast accessibility risks.
Acquire Codebase Knowledge
9sandbaseai/workbuddy-skill
Use when the user asks to map, document, or onboard into an existing codebase and needs evidence-backed architecture, structure, conventions, integrations, testing, and concerns documentation.
Project Bindings
9sandbaseai/workbuddy-skill
Use when authoring or changing a repository's project-specific bindings such as module ownership, workspace roots, database locations, gate keys, namespaces, palettes, registry contracts, or release values; keep facts in one authoritative declaration.
Mysql
9sandbaseai/workbuddy-skill
Use when inspecting a MySQL schema, writing or reviewing queries, diagnosing plans, designing indexes, or preparing database changes; default to read-only analysis and require explicit production mutation authority.
Schema Design
9sandbaseai/workbuddy-skill
Use when designing or reviewing relational schema changes, initialization SQL, migrations, privileges, seed data, constraints, indexes, or schema tests; preserve authority boundaries and verify the real database contract.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.