Postgres Skills
A Neon skill with Postgres 14 to 18 guidance: schema design, indexes, query tuning, migrations and common pitfalls.
- 56 ★ on the repository
- Last commit
- Apache-2.0
Minimal access
Why this level
- The skill consists of recommendations and references, never contacts a database and runs nothing.
Install
- Works in
In your terminal, with SkillFoxx CLI
npx skillfoxx add skills/postgres-skillsDetects the agents on your machine, shows the access level and pins the version.
Other ways to install
Access and checks
How we reviewMinimal accessThe tool runs nothing and makes no network calls.
- The skill consists of recommendations and references, never contacts a database and runs nothing.
This is third-party code. Review the repository files before installing.
What it does
Postgres Skills collects the experience of practitioners who built and scaled applications on Postgres. The set currently has one skill, `postgres-best-practices`. It covers schema design, index strategies, query optimization, migrations and common pitfalls, and activates when the agent writes SQL or designs a database. The skill covers PostgreSQL versions 14 through 18, and features of specific versions carry tags such as `[PG15+]`. The main `SKILL.md` is the entry point, and details sit in topic reference files: for example `references/schema-design.md` for tables, data types, normalization and partitioning. The agent opens them as needed.
Who it is for. Developers whose agents write SQL and design Postgres databases and should follow proven practices rather than guesses.
Good fit when
- The agent designs tables and picks data types, keys and normalization.
- A slow query is analyzed and the needed index is decided.
- A migration of a large table is prepared without needless locks.
- An old project is checked against Postgres versions nearing end of support.
Not a fit when
- Work is on MySQL, SQLite or another database.
- The agent needs live database access: the skill only advises and does not connect.
- The task is managing Neon infrastructure rather than Postgres itself.
Example request
Design an orders schema on Postgres 17 and propose indexes for the listed queries, following the skill guidance.Limitations
The skill covers Postgres 14 to 18 and no other databases. It does not connect to a database or run queries, and only gives the agent recommendations. Some examples depend on privileges, extensions or cluster configuration, and such places are marked in the text. Version 14 leaves support in November 2026. The set is gathered from well-known practitioners, yet it holds only one skill so far. The advice is provider-neutral and not tied to Neon, and you still need to measure load and the quirks of your own database.
How to disable. Remove the skill with `npx skills remove postgres-best-practices` or delete its folder from the agent skills directory.
FAQ
How do I install Postgres Skills?
Run `npx skills add neondatabase/postgres-skills`. The skill is picked up automatically once the agent starts working with SQL or a database schema.
Which Postgres versions are covered?
Versions 14 through 18. Features of specific versions carry tags such as `[PG15+]` and `[PG18+]`.
Is the skill tied to Neon?
The repository belongs to Neon, but the set principles are provider-neutral: the advice fits any Postgres deployment.
Who wrote the material?
Practitioners with deep Postgres experience. The README names reviewers, including Neon cofounder Stas Kelvich, and says authors are paid for their work.
Which topics do the references cover?
Schema design, indexes, query optimization, migrations and common pitfalls. For schemas there is the `references/schema-design.md` file.
Discussion
No questions or reviews yet.
Related
SkillsAn MCP server and skills from TigerData that help agents write PostgreSQL schemas and queries from current docs and practices
Neo4j skills for agents: Cypher queries, graph modeling, drivers, import, GraphRAG, GDS and Aura provisioning
ReskillSQL analyses failed agent SQL runs and ships query-writing skill versions only after checks on held-out examples.
A template for data scientists: AGENTS.md, CLAUDE.md and skills for Python, SQL, Polars and model diagnostics.
An agent skill that builds a Neo4j knowledge graph from CSV and Excel, writes safe Cypher and adds GraphRAG vector search.
31 skills for Claude Code and Codex for the analyst workflow: data checks, cohorts, funnels, A/B tests, dashboards, summaries
README in short
The goal is to give every AI engineer the experience of a senior Postgres specialist. The principles are vendor independence, curated authors with proven experience and paid contributions. The repository holds one skill and a plugin manifest for Claude Code.