Skip to content
Agentmart
Submit a tool

postgres-best-practices

Design, review, or optimize PostgreSQL schemas, queries, indexes, transactions, migrations, connections, and row-level security.

Skill by NeroWasTrolled

IndexedMIT
Write a review

Install

Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.

npx agentmarket install skill/nerowastrolled-postgres-best-practices

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

Design, review, or optimize PostgreSQL schemas, queries, indexes, transactions, migrations, connections, and row-level security. Do not guess performance without plans or measurements.

Use cases: design, backend, security

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.

Tools
No tools found
Secrets
None asked for
Install scripts
None found

Network hosts it talks to 1

  • codeload.github.com · found in install command

Files it touches

  • ~/.claude/skills/postgres-best-practices

What's inside

Skill name
postgres-best-practices
Description
Design, review, or optimize PostgreSQL schemas, queries, indexes, transactions, migrations, connections, and row-level security. Do not guess performance without plans or measurements.
License
MIT
Instructions
20 lines in SKILL.md · view on GitHub

Files (1)

  • SKILL.md

SKILL.md (first lines)

# PostgreSQL Best Practices

Match recommendations to the deployed PostgreSQL version and workload.

- Model constraints in the database where they protect real invariants.
- Choose types deliberately; avoid lossy text representations and unbounded JSON
  when relational structure is queried or constrained.
- Design indexes from verified query patterns, selectivity, ordering, and write cost.
- Use `EXPLAIN (ANALYZE, BUFFERS)` only on safe environments and representative data.
- Keep transactions short, define isolation expectations, and reason about locks.
- Use parameterized queries and least-privilege roles.
- Treat row-level security policies as authorization code and test cross-tenant denial.
- Make migrations observable, reversible where practical, and safe for table size,
  locks, concurrent application versions, and backfills.
- Bound pools according to database capacity; avoid connection multiplication.

For optimization, report the query, plan evidence, cardinality mismatch, proposed
change, tradeoff, and a before/after measurement. Do not add indexes reflexively.

From NeroWasTrolled/gabriel-ai-devkit, MIT.

More from NeroWasTrolled/gabriel-ai-devkit

Signals

Stars
0
Forks
0
Open issues
0
Last commit (this folder)
Sep 3, 2026 (1 month ago)

From GitHub (fetched Oct 24, 2026).

Details

License
MIT
Repository
github.com/NeroWasTrolled/gabriel-ai-devkit
First seen
Oct 24, 2026
Last checked
Oct 24, 2026
Source
GitHubgithub-graphql

More from NeroWasTrolled

Cite this page

postgres-best-practices skill. Agent Mart. https://agentmart.dev/skills/nerowastrolled-postgres-best-practices (last updated 2026-10-24)