Database Expert

This is a solid reference for PostgreSQL, MongoDB, and Redis fundamentals. It covers the essentials: schema design patterns, query optimization with EXPLAIN ANALYZE, indexing strategies including partial and covering indexes, and Redis caching patterns like cache-aside and distributed locking. The PostgreSQL section is the strongest with practical examples of CTEs, window functions, and triggers. Use this when you need quick syntax for common database operations or want to compare approaches across different database types. It won't make you a DBA, but it handles the 80% of database work that comes up in typical application development without having to context switch to documentation.

skills.sh installs: 251
GitHub stars: 108
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add travisjneuman/.claude --skill database-expert --agent claude-code

Installs into .claude/skills of the current project.

Files

Database Expert

Comprehensive guide for database design, optimization, and administration.

Database Selection

Database	Type	Best For
PostgreSQL	Relational	Complex queries, ACID, JSON support
MongoDB	Document	Flexible schemas, rapid iteration
Redis	Key-Value	Caching, sessions, real-time
SQLite	Embedded	Mobile, desktop, testing

PostgreSQL

Schema Design

-- Users table with proper constraints
CREATE TABLE users (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    email VARCHAR(255) NOT NULL UNIQUE,
    password_hash VARCHAR(255) NOT NULL,
    full_name VARCHAR(100) NOT NULL,
    status VARCHAR(20) NOT NULL DEFAULT 'active'
        CHECK (status IN ('active', 'inactive', 'suspended')),
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

-- Index for common queries
CREATE INDEX idx_users_email ON users(email);
CREATE INDEX idx_users_status ON users(status) WHERE status = 'active';

SKILL.md on GitHub