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

database-management-patterns — Claude Code skill: schemas, indexes

A reference skill for PostgreSQL and MongoDB work: schema design, indexing, transactions, replication and sharding.

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

What database-management-patterns does

The skill hands your agent ready-made patterns for database work. It opens with a comparison of relational and document stores, then walks through ACID and the CAP theorem, plus normal forms from 1NF to 3NF and the cases where denormalising pays off. The PostgreSQL section shows CREATE TABLE examples with SERIAL, UUID and composite primary keys, foreign keys using ON DELETE CASCADE, SET NULL and RESTRICT, and check plus partial unique constraints. Triggers and functions come next, though the source cuts off there.

The useful part is the material on indexing, transactions, replication and sharding for busy applications. Reach for it when you have to pick between SQL and NoSQL for a specific job, or when a query plan needs explaining after a slowdown.

Install runs through npx skills add with a platform flag: -a claude-code, -a codex, -a cursor, -a gemini-cli or -a opencode. GitHub Copilot uses a different command, gh skill install. The skill file lands in the platform's directory, for example ~/.claude/skills/database-management-patterns/SKILL.md.

What it helps with

  • design a table schema with keys and constraints
  • pick between PostgreSQL and MongoDB for a job
  • decide when denormalising is worth it
  • set up cascading deletes and referential integrity
  • plan how to scale a database with replication and sharding

Example prompts for the agent

  • Design a schema for orders and order items in PostgreSQL
  • Compare PostgreSQL and MongoDB for storing event logs
  • Why isn't this query using the index? Walk me through the plan

How to install database-management-patterns

1Skills CLI (Vercel)

npx skills add manutej/luxor-claude-marketplace --skill database-management-patterns -a claude-code

2Manually: put the files in place

~/.claude/skills/database-management-patterns/SKILL.md

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

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

Questions about database-management-patterns

How do I install database-management-patterns in Claude?

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

What does database-management-patterns do?

It collects database management patterns: schema design, indexing, transactions, replication, sharding and performance tuning for PostgreSQL and MongoDB.

Which platforms support this skill?

Claude, Codex, Cursor, GitHub Copilot, Gemini CLI and OpenCode. Each one has its own install command and skill file path.

Similar skills

All skills for Data and databases →
databases mrgoonie A skill that bundles MongoDB and PostgreSQL references: schemas, queries, indexes, migrations, backups and admin tasks. CX Codex +1 435installs optimize-database-performance davila7 A Claude slash command that walks through slow queries, indexes and schema, then tells you what to rewrite. Useful when a page stalls on one SELECT. 794installs database-administrator VoltAgent Community A subagent for database performance work, replication, backups, recovery, and production infrastructure. Use it when database reliability needs a structured review. 452installs nosql-database-design aj-geddes Guides the agent through NoSQL schema work: MongoDB collections, DynamoDB tables, embedding vs referencing, indexes. Useful before the schema hardens in code. CX Codex +1 486installs 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

api-gateway-patterns A skill for building API gateways on Kong: routing, rate limiting, auth, load balancing. Useful when your microservices exist but lack a single entry point. CX Codex +1 481installs react-patterns A skill that hands your agent ready React recipes: hooks, component composition, state management and fewer wasted re-renders. CX Codex +1 471installs SQLAlchemy ORM Expert A SQLAlchemy 2.0+ skill for customer support backends: ticket models, sessions, async queries and PostgreSQL. Useful when you build on FastAPI. CX Codex +1 470installs pandas A skill that brings pandas expertise to support operations: SLA compliance, agent metrics, PostgreSQL pulls. Useful when you need to dig through tickets and build a report. CX Codex +1 469installs 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

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