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

PostgreSQL Database Administration — Claude Code skill: what it does

A PostgreSQL administration skill: schema design, indexing, backups and query tuning. Useful when the agent writes SQL for a ticketing system or reporting.

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

What PostgreSQL Database Administration does

The skill covers PostgreSQL work for support systems: users, tickets, comments, change history, organizations and an audit log. It ships CREATE TABLE examples with constraints, foreign keys and JSONB columns for custom fields. The agent leans on those when it proposes a schema for your project.

There is a separate indexing section. B-tree indexes for common filters by status, customer and agent, partial indexes with a WHERE clause, composite ones on status, priority and date. Full-text search gets GIN and tsvector groundwork. Audit log partitioning is laid out by month.

You need access to a PostgreSQL 12 or newer installation, basic SQL knowledge and some comfort with the command line. Without a running server the examples stay text: you cannot check a query plan or see how an index behaves. The skill text stops partway through the full-text search section, so treat the GIN material and the rest as covered only by the listed capabilities.

What it helps with

  • design a ticketing schema with change history
  • pick indexes for status and agent filters
  • partition the audit log by month
  • store custom ticket fields in JSONB
  • set up full-text search over comments

Example prompts for the agent

  • Design a database schema for a support system: users, tickets, comments, history
  • Which indexes should I add to the tickets table for status and priority filters?
  • Split audit_logs into monthly partitions

How to install PostgreSQL Database Administration

1Skills CLI (Vercel)

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

2Manually: put the files in place

~/.claude/skills/postgresql/SKILL.md

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

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

Questions about PostgreSQL Database Administration

How do I install PostgreSQL Database Administration in Claude?

Run npx skills add manutej/luxor-claude-marketplace --skill postgresql-database-administration -a claude-code. The skill file lands at ~/.claude/skills/postgresql/SKILL.md.

What does this skill do?

It gives the agent PostgreSQL patterns for schemas, indexes, backups and query tuning in support systems.

What do I need for it to work?

Basic SQL, an understanding of relational databases, command-line familiarity and access to a PostgreSQL 12 or newer installation.

Similar skills

All skills for Data and databases →
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-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 postgresql devops-skills Guides PostgreSQL database administration, streaming replication, backups, and performance tuning. Useful when deploying or optimizing database instances. CX Codex +1 419installs 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-performance-debugging aj-geddes A skill that walks your agent through finding slow SQL queries and reading their execution plans. Useful when the app drags or the database burns CPU. CX Codex +1 493installs

From the same set31

react-development A skill that feeds your coding agent React patterns: components, hooks, state and effects, taken from the official react.dev docs. CX Codex +1 464installs tailwind-css A Tailwind CSS skill covering utility classes, responsive variants, dark mode and production optimization. Handy when you build UI and want to stay in your markup. CX Codex +1 461installs vector-database-management A skill for Pinecone, Weaviate and Chroma: indexes, embeddings, similarity search and RAG. Useful when you need semantic search in a project. CX Codex +1 459installs performance-benchmark-specialist Sets up benchmarks for shell tools: warmup runs, statistics, and target checks like <100ms and >90% cache hit rate. CX Codex +1 456installs langchain-orchestration A LangChain reference skill for your coding agent: chains, agents, memory, RAG and orchestration. Useful when the agent writes LangChain code and should stick to working patterns. CX Codex +1 451installs graphql-api-development A skill that walks your agent through GraphQL API design on graphql-js: schema, resolvers, queries, mutations, subscriptions, auth. Useful when REST stops fitting. CX Codex +1 447installs microservices-patterns A microservices skill covering service mesh, circuit breakers, traffic splitting and Istio. Useful when services fail in cascades or you need a canary release. CX Codex +1 446installs dbt-data-transformation A dbt skill for analytics engineering: models, tests, docs, incremental builds, macros and packages. Useful when your warehouse SQL needs structure. CX Codex +1 441installs

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