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.

9 stars 3 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add sandbaseai/workbuddy-skill --skill postgres-engineering
Manual install
git 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-engineering

Personal 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.
Read the full skill on GitHub

Details

Skill name
postgres-engineering
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

9

sandbaseai/workbuddy-skill

Design, review, implement, and verify least-privilege access controls across users, services, tenants, resources, and administrative workflows.

Security

Accessibility Review

9

sandbaseai/workbuddy-skill

Use when reviewing a web interface or interaction for semantic, keyboard, focus, screen-reader, ARIA, and contrast accessibility risks.

Frontend & Design

Acquire Codebase Knowledge

9

sandbaseai/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.

Software Development

Project Bindings

9

sandbaseai/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.

Databases

Mysql

9

sandbaseai/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.

Databases

Schema Design

9

sandbaseai/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.

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.