PostgreSQL Table Design
Design and review PostgreSQL schemas: types, indexes, constraints, partitioning
- What
- Design and review PostgreSQL schemas: types, indexes, constraints, partitioning
- Cost
- Free
- Needs
- a PostgreSQL database to design or review (any version; PG15+ notes for NULLS NOT DISTINCT)
- Install
- Copy the installer prompt below into your Muse — your agent does the rest.
Curated by Skill Harbor — a PostgreSQL schema design skill: core rules and decision points for designing or reviewing a PostgreSQL-specific schema — column types, primary keys, normalization, indexes, constraints, and partitioning — with the full data-type catalog, workload patterns (update-heavy, insert-heavy, upsert, schema evolution), extensions, JSONB indexing and worked DDL examples living in `references/details.md`. Packed with PostgreSQL gotchas the skill insists on: PostgreSQL never auto-indexes foreign-key columns, UNIQUE allows multiple NULLs, unquoted identifiers get lowercased, sequences have gaps by design. By @wshobson, listed here with credit to its creator. Honest caveats: PostgreSQL-specific — the type choices and index rules don't transfer to MySQL or SQLite; the deep material is in the reference file, so the agent needs to open it, not just skim the skill. Skill Harbor never reviews the code, review it yourself before use.
Version:
Install
Prerequisites: a PostgreSQL database to design or review (any version; PG15+ notes for NULLS NOT DISTINCT) Install "PostgreSQL Table Design" for me. Design and review PostgreSQL schemas: types, indexes, constraints, partitioning Repository: https://github.com/wshobson/agents/blob/main/plugins/database-design/skills/postgresql-table-design/SKILL.md 1. Fetch the SKILL.md file for the wshobson-postgresql-table-design skill from the repository into a temporary folder and summarize what it does in one or two sentences. 2. Safety check: review the SKILL.md and scripts for anything suspicious (unexpected network calls, shell commands, credential harvesting). This repo should contain zero secrets in code, credentials only via the secure vault, allowed hosts declared in the SKILL.md. Verify that holds here; STOP on any red flag and tell me. 3. Install it as a skill: copy SKILL.md and its helper files into the agent's skills directory, in a folder named "wshobson-postgresql-table-design". 4. Verify with no network calls: frontmatter valid, files in place. 5. Report what was installed, where, and what I still need to do myself (e.g. any accounts, API keys, or CLI tools mentioned in the prerequisites above). GitHub is optional: if I have a GitHub account or the gh CLI, you may use it; otherwise public access is fine. Never require it unless it's in the prerequisites above. Rules: don't touch anything outside the temp folder and the install target. Never ask me to paste secrets in chat — credentials go through the secure vault or environment variables. If anything looks off, stop and ask me.
Questions
How do I install a build?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the build up for you — no manual configuration.
Where does my money go?
Straight to the seller. Skill Harbor never processes payments: checkout happens on the seller’s own page, usually Stripe.
What does the ✓ next to a creator’s name mean?
It means we confirmed the identity of the person behind the listing. It says nothing about the code itself — always check a build before installing it.