Skip to main content
affpapa.org
RU EN
skill CX Codex

postgresql-database-engineering — Claude Code skill: how to install

Guides database design, index selection, and query optimization in PostgreSQL. Useful when tuning slow queries, setting up table partitioning, or configuring replication.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add manutej/luxor-claude-marketplace --skill postgresql-database-engineering -a claude-code
Open on GitHub

What postgresql-database-engineering does

The skill supplies your coding agent with engineering guidelines for PostgreSQL. It covers transaction isolation levels, connection pooling with pgBouncer or PgPool, and query plan diagnosis via EXPLAIN ANALYZE. The material details engine internals, including shared memory, write-ahead logs, and multi-version concurrency control mechanics where VACUUM reclaims dead tuple storage.

Index guidance spans six access methods, from standard B-Tree to BRIN for append-only datasets. GiST handles geometric types, while GIN covers array and JSONB searches. Index selection requires tradeoffs. GIN indexes slow down writes, while hash indexes support only strict equality.

For massive datasets with 100M+ rows, the skill outlines declarative range, list, and hash partitioning. This setup enables partition pruning, letting the planner discard irrelevant tables before reading disk blocks.

What it helps with

  • choose appropriate index types for JSONB, arrays, and geometric data
  • optimize slow queries using EXPLAIN ANALYZE execution plans
  • partition large tables exceeding 100M rows by range, list, or hash
  • configure connection pooling with pgBouncer or PgPool
  • tune autovacuum to reclaim space from dead tuples under MVCC

Example prompts for the agent

  • Analyze this EXPLAIN ANALYZE output and suggest whether to use a B-Tree or BRIN index
  • Help me set up monthly range partitioning for an events table with over 100M rows
  • Review our VACUUM and transaction isolation settings to handle frequent updates without table bloat

How to install postgresql-database-engineering

1Skills CLI (Vercel)

npx skills add manutej/luxor-claude-marketplace --skill postgresql-database-engineering -a claude-code

2Manually: put the files in place

~/.claude/skills/postgresql-database-engineering/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/postgresql-database-engineering/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about postgresql-database-engineering

How do I install postgresql-database-engineering in Claude Code?

Run npx skills add manutej/luxor-claude-marketplace --skill postgresql-database-engineering -a claude-code in your terminal. You can also place the skill file directly at ~/.claude/skills/postgresql-database-engineering/SKILL.md.

What does postgresql-database-engineering do?

It equips your AI assistant with database engineering rules for PostgreSQL. The skill covers index selection, query optimization with EXPLAIN, MVCC maintenance, and table partitioning.

When does the skill suggest using BRIN instead of B-Tree indexes?

BRIN is suggested for massive, naturally sorted datasets such as time-series and append-only logs. It creates very small indexes that scale to billions of rows by summarizing data across block ranges.

Similar skills

All skills for Data and databases →
postgresql-best-practices Mindrally A skill that feeds your agent PostgreSQL rules: data types, schema design, indexing, query plans and database maintenance. CX Codex +1 1,500installs database-optimizer https://github.com/Jeffallan Investigates slow PostgreSQL and MySQL queries, breaks down execution plans with EXPLAIN ANALYZE, and drafts indexes without table locks. CX Codex +1 6,000installs PostgreSQL Database Administrator official github Subagent for managing PostgreSQL databases with the VS Code extension. It executes queries, inspects schemas, and handles admin tasks directly in Copilot. ★ 40,418repo stars postgresql-expert PCL Team A skill that turns the agent into a PostgreSQL expert: advanced queries, indexes, performance tuning and production operations. Useful whenever a task touches schema, SQL or query plans. CX Codex +1 424installs database-design MoizIbnYousaf A skill for schema design, migrations and query optimization on PostgreSQL, MySQL and NoSQL. Useful whenever the agent writes SQL. CX Codex +1 604installs database-indexing-strategy aj-geddes A skill for planning indexes: picks the type, builds composite and partial ones, covers maintenance. Useful when queries slow down. CX Codex +1 486installs

From the same set31

jest-react-testing A skill for testing React components and hooks with Jest and React Testing Library: config, mocks, async patterns. CX Codex +1 1,200installs ui-design-patterns A reference on common interface patterns: navigation, forms, data display, feedback and accessibility. Useful when you design components or audit an existing UI. CX Codex +1 853installs ux-principles Gives your coding agent usability heuristics, user research methods and accessibility checks, so interface work follows known rules instead of guesswork. CX Codex +1 836installs frontend-architecture A skill for planning frontend structure: layers, patterns, state management and module boundaries. Useful once an app outgrows a flat folder of components. CX Codex +1 722installs alembic A skill that walks your agent through Alembic migrations on SQLAlchemy projects, from alembic init to production rollout and rollback. CX Codex +1 644installs wireframing A skill for interface design work: it walks from rough sketches and screen structure to a layout close to the final design. CX Codex +1 566installs expressjs-development A skill that feeds your coding agent Express.js patterns: routing, middleware, request and response handling, error handling. CX Codex +1 555installs mobile-design A skill for mobile interfaces: touch targets, gestures, thumb zones, safe areas and mobile-first layout for small screens. CX Codex +1 545installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor