Data Relational Database

Use when the user asks about PostgreSQL or MySQL indexing, EXPLAIN ANALYZE, partitioning, streaming or logical replication, autovacuum, connection pooling (PgBouncer) or query optimization. Produces index, partition, replication and pooling configs. Not for engine theory such as MVCC internals (use database-internals-mechanics) or sharding (use architecture-database-scaling).

45 stars 6 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add j4flmao/agent-skills --skill data-relational-database
Manual install
git clone --depth 1 https://github.com/j4flmao/agent-skills.git /tmp/agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/agent-skills/skills/data/relational-database ~/.claude/skills/data-relational-database

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Data Relational Database

## Purpose
Design relational database schemas with proper indexing, partitioning, replication, connection pooling, and query optimization strategies.

## Agent Protocol

### Trigger
Exact user phrases: "PostgreSQL", "MySQL", "relational database", "partitioning", "replication", "indexing", "vacuum", "connection pooling", "query optimization", "EXPLAIN", "CTE", "window function", "transaction isolation", "migration", "PgBouncer", "MVCC", "WAL", "B-tree", "GiST", "GIN", "BRIN".

### Input Context
Before activating, verify:
- Database platform (PostgreSQL, MySQL, MariaDB, SQLite)
- Data volume (rows, growth rate, total size in GB/TB)
- Query workload (OLTP, OLAP, mixed)
- Current schema and migration tool (Alembic, Sqitch, Flyway, Liquibase)
- Existing indexing strategy and planner statistics
- Replication needs (read replicas, disaster recovery, logical replication)
- Connection pooling requirements (client count, max connections)

### Output Artifact
Database schema with indexes, partition configuration, replication setup, and query optimization plan as SQL and YAML.

### Response Format
```sql
-- Table DDL with partitioning
-- Index creation statements
-- Replication configuration
-- Migration statements
```
```yaml
# Connection pool config
# Replication setup
# Vacuum settings
```

No preamble. No postamble. No explanations. No filler/hedging/transitions. Compress output — why use many token when few do trick.

### Completion Criteria
Read the full skill on GitHub

Details

Skill name
data-relational-database
Path
skills/data/relational-database/SKILL.md
License
MIT
Repo updated
17 November 2026

FAQ

What does the Data Relational Database skill do?

Use when the user asks about PostgreSQL or MySQL indexing, EXPLAIN ANALYZE, partitioning, streaming or logical replication, autovacuum, connection pooling (PgBouncer) or query optimization. Produces index, partition, replication and pooling configs. Not for engine theory such as MVCC internals (use database-internals-mechanics) or sharding (use architecture-database-scaling).

How do I install the Data Relational Database skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add j4flmao/agent-skills --skill data-relational-database. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Data Relational Database popular?

It lives in j4flmao/agent-skills, which has 45 GitHub stars and 6 forks.

Related skills

Agent Observability

45

j4flmao/agent-skills

Use when the user asks about agent observability, tracing agent reasoning, debugging an agent loop, OpenTelemetry GenAI spans for LLM calls, LLM cost tracking per agent, agent audit logs or hallucination/eval monitoring in production. Produces instrumentation config, trace schema, dashboards, alerts and cost attribution. Not for generic service tracing without LLMs (use devops-opentelemetry).

DevOps & Cloud

AI Agent Architectures

45

j4flmao/agent-skills

Use when the user asks to build an AI agent, design an agent that calls tools and keeps memory, write an agent system prompt or pick an agent framework (Claude Agent SDK, OpenAI Agents SDK, LangGraph). Produces an architecture brief covering loop, tools, memory, guardrails and evals, routing depth to child skills. Not for workflow patterns (use ai-agentic-workflows).

AI, LLMs & Agents

AI Agent Core Loop

45

j4flmao/agent-skills

Use when the user asks about the agent loop, ReAct vs plan-and-solve, re-planning, Reflexion, an agent stuck in a loop, max iterations or termination conditions. Produces a loop spec or patch with state, success predicate, caps and no-progress detection. Not for overall agent design (use ai-agent-architectures) or tool schemas (use tool-calling-principles).

AI, LLMs & Agents

Database Internals Mechanics

45

j4flmao/agent-skills

Use when the user asks to explain MVCC and the write-ahead log (WAL), B-tree vs LSM tree, compaction, write amplification, storage engines, isolation levels, write skew, serializable snapshot isolation or vacuum bloat. Produces an engine explanation turned into concrete engine, key and isolation choices. Not for PostgreSQL ops tuning (use data-relational-database).

Databases

Data Nosql Database

45

j4flmao/agent-skills

Use when the user asks about MongoDB, Cassandra, DynamoDB single-table design, Cosmos DB, Couchbase, partition keys, GSIs, consistency levels or NoSQL denormalization. Produces database choice, access-pattern-driven data model and capacity settings. Not for graph databases (use data-graph-database) or Redis caching (use backend-caching).

Databases

Database Migration

45

j4flmao/agent-skills

Use when the user asks about schema migrations, Flyway, Liquibase, Alembic, Prisma Migrate, zero-downtime expand/contract changes, AWS DMS, heterogeneous database moves, or schema drift. Produces safe migration scripts, rollout order and validation. Not for whole-workload cloud migration (use cloud-migration).

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.