Claude Directory

Claude Code setups for databases

Query, migrate, and optimize across SQL and NoSQL. MCP servers, skills, and agents for Postgres, MySQL, Redis, MongoDB, BigQuery, and more — wired into Claude Code so you can ask the database questions in natural language.

130 items across skills, agents, plugins, MCP servers, prompts, hooks, and guides.

Example prompts

Concrete things you can type into Claude Code for databases. Each example uses a real skill, agent, slash command, hook, or MCP server listed below.

Query Postgres without leaving the editor

Connect the Postgres MCP server, then ask: 'show me the slowest queries from the last hour and their plans.'

Write a safe migration

Use the migrate-db skill to add a NOT NULL column to a 50M-row users table without holding a long lock.

Optimize a slow query

Use the sql-optimizer skill on the orders dashboard query and explain the plan in plain English.

Introspect a live DB into Prisma

Use the Prisma MCP server to introspect the staging DB and generate schema.prisma.

Skills (18)

Browse all skills

SQL Query Optimizer

Analyze slow SQL queries, explain the execution plan, and suggest indexes or rewrites to make them fast

sqldatabaseperformancequery-optimization+3

Database Migration Planner

Plan and generate safe database migrations with rollback strategies and zero-downtime deployment considerations

databasemigrationssqlschema+1

Designs and implements backend systems including REST APIs, microservices, database architectures, authentication flows, and security hardening. Use when the user asks to "design REST APIs", "optimize database queries", "implement authentication", "build microservices", "review …

nodepostgressecurityapi+2

Generate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation. Use when writing SQL, building data reports, exploring databases, or translating business questions …

Api Rate Limiting

Implements API rate limiting using token bucket, sliding window, and Redis-based algorithms to protect against abuse. Use when securing public APIs, implementing tiered access, or preventing denial-of-service attacks.

Use when working with Redis in Bun (ioredis, Upstash), caching, pub/sub, session storage, or key-value operations.

Cloudflare Hyperdrive

Cloudflare Hyperdrive for Workers-to-database connections with pooling and caching. Use for PostgreSQL/MySQL, Drizzle/Prisma, or encountering pool errors, TLS issues, connection refused.

postgresmysqlcloudflare

Database Schema Design

Database schema design for PostgreSQL/MySQL with normalization, relationships, constraints. Use for new databases, schema reviews, migrations, or encountering missing PKs/FKs, wrong data types, premature denormalization, EAV anti-pattern.

postgresmysqlai

Database Sharding

Database sharding for PostgreSQL/MySQL with hash/range/directory strategies. Use for horizontal scaling, multi-tenant isolation, billions of records, or encountering wrong shard keys, hotspots, cross-shard transactions, rebalancing issues.

FastMCP Python framework for MCP servers with tools, resources, storage backends (memory/disk/Redis/DynamoDB). Use for Claude tool exposure, OAuth Proxy, cloud deployment, or encountering storage, lifespan, middleware, circular import, async errors.

pythonredisdeploymentrag

Idempotency Handling

Idempotent API operations with idempotency keys, Redis caching, DB constraints. Use for payment systems, webhook retries, safe retries, or encountering duplicate processing, race conditions, key expiry errors.

Neon Vercel Postgres

Neon + Vercel serverless Postgres for edge and serverless environments. Use for Cloudflare Workers, Vercel Edge, Next.js apps with HTTP/WebSocket connections, database branching (git-like), Drizzle/Prisma ORM integration, migrations, PITR backups, or encountering connection pool…

postgresvercelcloudflare

| Nuxt 4 server-side development with Nitro: API routes, server middleware, database integration, and backend patterns. Use when: creating server API routes, implementing server middleware, integrating databases (D1, PostgreSQL, Drizzle), handling file uploads, implementing WebS…

Session Management

Implements secure session management with JWT tokens, Redis storage, refresh flows, and proper cookie configuration. Use when building authentication systems, managing user sessions, or implementing secure logout functionality.

Sql Query Optimization

SQL query optimization for PostgreSQL/MySQL with indexing, EXPLAIN analysis. Use for slow queries, N+1 problems, missing indexes, or encountering sequential scans, OFFSET pagination, temp table spills, inefficient JOINs.

postgresmysqlai

Supabase Postgres Best Practices

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

postgresperformance

Vercel KV (Redis-compatible key-value storage via Upstash). Use for Next.js caching, sessions, rate limiting, TTL data storage, or encountering KV_REST_API_URL errors, rate limit issues, JSON serialization errors. Provides strong consistency vs eventual consistency.

redisvercelapirest+1

Redis Cache Manager

Manage redis cache manager operations. Auto-activating skill for Backend Development. Triggers on: redis cache manager, redis cache manager Part of the Backend Development skill category. Use when working with redis cache manager functionality. Trigger with phrases like "redis c…

Agents (3)

Browse all agents

Data pipeline specialist for ETL processes, data warehousing, and analytics infrastructure

Data & AIdata-engineeringetl+3

Database Expert

Specialist in SQL and NoSQL database design, query optimization, migrations, and performance tuning

Data & AIdatabasesql+4

Full-Stack Developer

Versatile full-stack engineer who builds complete features across frontend, backend, database, and infrastructure layers

Developmentfull-stackfrontend+6

Plugins (64)

Browse all plugins

Supabase backend integration. Database operations, authentication, storage, real-time subscriptions, project management, and SQL query execution directly from Claude Code.

databasebackendauthenticationintegration+1

Google Firebase MCP integration. Comprehensive backend management including Firestore databases, authentication, cloud functions, hosting, and storage solutions integrated into your development workflow.

databasebackendgoogleauthentication+1

Prisma ORM integration for database management. Generate schemas, run migrations, explore data with Prisma Studio, and manage database workflows.

databaseormtypescriptofficial

Query MongoDB collections, inspect schemas, build aggregation pipelines, and manage indexes with natural language from Claude Code

databasemongodbnosqldata+1

Inspect Redis keys, monitor cache hit rates, debug pub/sub channels, and manage data structures through Claude Code

databaserediscachedata+1

Create, connect, and interact with an AlloyDB for PostgreSQL database and data.

databasepostgres

Azure Cosmos Db Assistant

Expert assistant for Azure Cosmos DB — data modeling, query optimization, performance tuning, and best practices.

databaseazureperformance

Official Bigdata.com plugin providing financial research, analytics, and intelligence tools powered by Bigdata MCP.

Connect Claude to your ClickHouse Cloud databases. Browse organizations, services, databases, and table schemas. Run read-only SQL queries against your data and get instant analytical answers. Monitor service backups, review billing costs, and inspect ClickPipe configurations - …

Cloud Sql Postgresql

Create, connect, and interact with a Cloud SQL for PostgreSQL database and data.

databasepostgres

Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database clusters. This plugin provides 14 tools across two active MCP backends (self-hosted MCP Toolbox and managed…

Databases On Aws

Expert database guidance for the AWS database portfolio. Design schemas, execute queries, handle migrations, and choose the right database for your workload.

Agent skills for building on, analyzing, and managing Microsoft Dataverse — with Dataverse MCP, PAC CLI, and Python SDK.

databasepythonagent

Manage your Neon projects and databases with the neon-postgres agent skill and the Neon MCP Server.

databasepostgresagent

Pinecone vector database integration. Streamline your Pinecone development with powerful tools for managing vector indexes, querying data, and rapid prototyping. Use slash commands like /quickstart to generate AGENTS.md files and initialize Python projects and /query to quickly …

databasepythonapiagent

An authenticated hosted MCP server that accesses your PlanetScale organizations, databases, branches, schema, and Insights data. Query against your data, surface slow queries, and get organizational and account information.

Agent skills for Qdrant vector search covering scaling, performance optimization, search quality, monitoring, deployment, model migration, version upgrades, and SDK usage across Python, TypeScript, Rust, Go, .NET, and Java.

databasepythontypescriptrust+5

Zilliz Cloud management plugin with 14 skills covering cluster lifecycle, collection schema, vector search, index tuning, bulk import, RBAC, backups, and monitoring.

databasemonitoring

Api Cache Manager

Implement caching strategies with Redis, CDN, and HTTP headers

api-developmentredisapi

Api Rate Limiter

Implement rate limiting with token bucket, sliding window, and Redis

api-developmentredisapi

Data Seeder Generator

Generate realistic test data and database seed scripts for development and testing environments

databasetesting

Data Validation Engine

Database plugin for data-validation-engine

Database Archival System

Database plugin for database-archival-system

Database Audit Logger

Database plugin for database-audit-logger

Database Backup Automator

Automate database backups with scheduling, compression, encryption, and restore procedures

Database Cache Layer

Database plugin for database-cache-layer

Database Connection Pooler

Implement and optimize database connection pooling for improved performance and resource management

databaseperformance

Database Deadlock Detector

Database plugin for database-deadlock-detector

Database Diff Tool

Database plugin for database-diff-tool

Database Documentation Gen

Database plugin for database-documentation-gen

Database Health Monitor

Database plugin for database-health-monitor

Database Index Advisor

Analyze query patterns and recommend optimal database indexes with impact analysis

Database Migration Manager

Manage database migrations with version control, rollback capabilities, and automated schema evolution tracking

Database Partition Manager

Database plugin for database-partition-manager

Database Recovery Manager

Database plugin for database-recovery-manager

Database Replication Manager

Manage database replication, failover, and high availability configurations

Database Schema Designer

Design and visualize database schemas with normalization guidance, relationship mapping, and ERD generation

Database Security Scanner

Database plugin for database-security-scanner

databasesecurity

Database Sharding Manager

Database plugin for database-sharding-manager

Database Transaction Monitor

Database plugin for database-transaction-monitor

Fairdb Operations Kit

Complete operations kit for FairDB PostgreSQL as a Service - VPS setup, PostgreSQL management, customer provisioning, monitoring, and backup automation

devopspostgresmonitoringautomation+1

Fairdb Ops Manager

Database operations management for FairDB PostgreSQL clusters

communitypostgresai

Freshie Inventory Manager

Interactive command center for the freshie ecosystem inventory database — conversational wizard with subagents for discovery scans, compliance grading, batch remediation, querying, reporting, and email PDF delivery across 50 tables of plugin/skill/pack metadata

databaseaiagent

Fullstack Starter Pack

Complete fullstack development toolkit: React, Express/FastAPI, PostgreSQL scaffolding with AI agents

packagesreactpostgresapi+2

Nosql Data Modeler

Database plugin for nosql-data-modeler

Orm Code Generator

Generate ORM models from database schemas or create database schemas from models for TypeORM, Prisma, Sequelize, SQLAlchemy, and more

Query Performance Analyzer

Analyze query performance with EXPLAIN plan interpretation, bottleneck identification, and optimization recommendations

databaseperformanceai

Sql Query Optimizer

Analyze and optimize SQL queries for better performance, suggesting indexes, query rewrites, and execution plan improvements

databaseperformance

Stored Procedure Generator

Database plugin for stored-procedure-generator

Database Design

Database architecture, schema design, and SQL optimization for production systems

Database Migrations

Database migration automation, observability, and cross-database migration strategies

databaseautomation

Api Rate Limiting

Implements API rate limiting using token bucket, sliding window, and Redis-based algorithms to protect against abuse. Use when securing public APIs, implementing tiered access, or preventing denial-of-service attacks.

Cloudflare Hyperdrive

Cloudflare Hyperdrive for Workers-to-database connections with pooling and caching. Use for PostgreSQL/MySQL, Drizzle/Prisma, or encountering pool errors, TLS issues, connection refused.

cloudflarepostgresmysql

Database Schema Design

Database schema design for PostgreSQL/MySQL with normalization, relationships, constraints. Use for new databases, schema reviews, migrations, or encountering missing PKs/FKs, wrong data types, premature denormalization, EAV anti-pattern.

databasepostgresmysqlai

Database Sharding

Database sharding for PostgreSQL/MySQL with hash/range/directory strategies. Use for horizontal scaling, multi-tenant isolation, billions of records, or encountering wrong shard keys, hotspots, cross-shard transactions, rebalancing issues.

databasepostgresmysql

Type-safe ORM for Cloudflare D1 databases using Drizzle. Use when: building D1 database schemas, writing type-safe SQL queries, managing migrations with Drizzle Kit, defining table relations, implementing prepared statements, using D1 batch API, or encountering D1_ERROR, transac…

databasecloudflareapi

FastMCP Python framework for MCP servers with tools, resources, storage backends (memory/disk/Redis/DynamoDB). Use for Claude tool exposure, OAuth Proxy, cloud deployment, or encountering storage, lifespan, middleware, circular import, async errors.

toolingpythonredisdeployment+1

Idempotency Handling

Idempotent API operations with idempotency keys, Redis caching, DB constraints. Use for payment systems, webhook retries, safe retries, or encountering duplicate processing, race conditions, key expiry errors.

toolingredisapiai

Neon Vercel Postgres

Neon + Vercel serverless Postgres for edge and serverless environments. Use for Cloudflare Workers, Vercel Edge, Next.js apps with HTTP/WebSocket connections, database branching (git-like), Drizzle/Prisma ORM integration, migrations, PITR backups, or encountering connection pool…

databasepostgresvercelcloudflare

Session Management

Implements secure session management with JWT tokens, Redis storage, refresh flows, and proper cookie configuration. Use when building authentication systems, managing user sessions, or implementing secure logout functionality.

Sql Query Optimization

SQL query optimization for PostgreSQL/MySQL with indexing, EXPLAIN analysis. Use for slow queries, N+1 problems, missing indexes, or encountering sequential scans, OFFSET pagination, temp table spills, inefficient JOINs.

datapostgresmysqlai

Supabase Postgres Best Practices

Postgres performance optimization and best practices from Supabase. 30 rules across 8 categories prioritized by impact.

toolinggopostgresperformance

Vercel Blob object storage with CDN for Next.js. Use for file uploads (images, PDFs, videos), presigned URLs, user-generated content, file management, or encountering BLOB_READ_WRITE_TOKEN errors, file size limits, client upload token errors.

databasevercelrag

Vercel KV (Redis-compatible key-value storage via Upstash). Use for Next.js caching, sessions, rate limiting, TTL data storage, or encountering KV_REST_API_URL errors, rate limit issues, JSON serialization errors. Provides strong consistency vs eventual consistency.

databaseredisvercelapi+2

MCP Servers (45)

Browse all MCP servers

Supabase Server

Interact with Supabase databases, authentication, storage, and edge functions through natural language

databasesupabasepostgresauth+2

Query, aggregate, and manage MongoDB databases with schema inspection and natural language operations

databasemongodbnosqlcommunity

PostgreSQL Server

Query and manage PostgreSQL databases with read-only access by default

databasepostgressql

Interact with SQLite databases for queries, schema inspection, and data analysis

databasesqlitesqlofficial

Official Redis MCP server for data storage, caching, and search operations through natural language

databaserediscachesearch+1

Neo4j Graph Database

Query and manage Neo4j graph databases with Cypher operations and schema exploration

databaseneo4jgraphcypher+1

Snowflake Server

Query and interact with Snowflake data warehouse for analytics and data engineering workflows

snowflakedatabasedata-warehouseanalytics+1

BigQuery Server

Query and analyze data in Google BigQuery for large-scale data analytics and machine learning

bigquerygoogledatabasedata-warehouse+2

Airtable Server

Query and manage Airtable bases, tables, and records for low-code database operations

airtabledatabasespreadsheetno-code+1

Manage Neon serverless Postgres databases, branches, and SQL queries for modern cloud-native applications

databasepostgresserverlessneon+1

Interact with Turso/LibSQL edge databases for low-latency, globally distributed SQLite-compatible storage

databasetursolibsqlsqlite+1

Manage Upstash serverless Redis, Kafka, and QStash for event-driven and caching workloads

databaserediskafkaserverless+1

ClickHouse Server

Query and manage ClickHouse analytical databases for real-time analytics and large-scale data processing

clickhousedatabaseanalyticsolap+1

Interact with Prisma ORM to manage database schemas, run migrations, and query data

prismaormdatabaseschema+2

Interact with dbt Core and dbt Cloud for data transformations, model execution, test runs, and documentation generation

dbtdata-engineeringsqlanalytics+1

Secure interaction with MySQL databases for queries, schema inspection, and data management

databasemysqlsqlcommunity

Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.

aggregatorspostgresmysqlsqlite

Manage your Redis Cloud resources effortlessly using natural language. Create databases, monitor subscriptions, and configure cloud deployments with simple commands.

cloud-platformsredisdeployment

🐍 ☁️ 🎖️ - Navigate your [Aiven projects](https://go.aiven.io/mcp-server) and interact with the PostgreSQL®, Apache Kafka®, ClickHouse® and OpenSearch® services

databasesgopostgresai

MySQL database integration in NodeJS with configurable access controls and schema inspection

databasesnodemysql

MCP and MCP SSE Server that automatically generate API based on database schema and data. Supports PostgreSQL, Clickhouse, MySQL, Snowflake, BigQuery, Supabase

databasespostgresmysqlapi

All-in-one MCP server for Postgres development and operations, with tools for performance analysis, tuning, and health checks

databasespostgresperformance

user-friendly read-only mysql mcp server for cursor and n8n...

MySQL database integration with configurable access controls, schema inspection, and comprehensive security guidelines

databasesmysqlsecurity

Node.js-based MySQL database integration that provides secure MySQL database operations

databasesnodemysql

A high-performance multi-database MCP server built with Golang, supporting MySQL & PostgreSQL (NoSQL coming soon). Includes built-in tools for query execution, transaction management, schema exploration, query building, and performance analysis, with seamless Cursor integration …

databasesgopostgresmysql+1

Run Sql Connectorx

An MCP server that executes SQL via ConnectorX and streams the result to a CSV or Parquet file. Supports PostgreSQL, MariaDB, BigQuery, RedShift, MS SQL Server, etc.

databasespostgres

PostgreSQL MCP server with 14 tools for querying, schema exploration, and table analysis. Features security-first design with SQL injection prevention and read-only by default.

databasespostgressecurity

An MCP Server for creating and managing Postgres databases using Neon Serverless Postgres

databasespostgres

Manage and query Postgres databases, tenants, users, auth using LLMs

databasespostgresllm

provides AI-powered PostgreSQL performance tuning capabilities.

databasespostgresperformanceai

MCP server for secure database access (PostgreSQL, MySQL, SQLite) with parameterized queries and schema inspection

databasespostgresmysqlsqlite

Gives LLMs the ability to manage Prisma Postgres databases (e.g. spin up new databases and run migrations or queries).

databasespostgresllm

The Redis official MCP Server offers an interface to manage and search data in Redis.

Universal SQLAlchemy-based database integration supporting PostgreSQL, MySQL, MariaDB, SQLite, Oracle, MS SQL Server and many more databases. Features schema and relationship inspection, and large dataset analysis capabilities.

databasespostgresmysqlsqlite

Natural language PostgreSQL queries with automatic streaming, read-only safety, and universal database compatibility.

databasespostgres

Mysql Mcp Server Pro

Supports SSE, STDIO; not only limited to MySQL's CRUD functionality; also includes database exception analysis capabilities; controls database permissions based on roles; and makes it easy for developers to extend tools with customization

A universal database MCP server supporting simultaneous connections to multiple databases. It provides tools for database operations, health analysis, SQL optimization, and more. Compatible with mainstream databases including MySQL, PostgreSQL, SQL Server, MariaDB, Dameng, and O…

databasespostgresmysqlai

Easy to use, zero dependency MySQL MCP server built with Golang with configurable readonly mode and schema inspection.

databasesgomysql

Local-first codebase intelligence engine. Gives coding agents structured context packets, indexed code/schema facts, and diagnostics over MCP, backed by a local SQLite store — so agents stop rediscovering your repo with raw grep. Optional Postgres/Supabase awareness and a bundle…

developer-toolspostgresredissqlite+1

Endor lets your AI agents run services like MariaDB, Postgres, Redis, Memcached, Alpine, or Valkey in isolated sandboxes. Get pre-configured applications that boot in less than 5 seconds.

developer-toolspostgresredisai+1

AI-native backend-as-a-service platform enabling AI agents to build and manage full-stack applications. Provides Auth, Database (PostgreSQL), Storage, and Functions as production-grade infrastructure, reducing MVP development time from weeks to hours.

developer-toolspostgresairag+1

Subscription Tracker

MCP server for intelligent subscription management with Gmail + MySQL integration.

finance-fintechmysqlai

Persistent memory for Claude Code grounded in computational neuroscience (41 cited papers). Thermodynamic decay, hippocampal-cortical consolidation, predictive-coding write gate, WRRF retrieval. PostgreSQL + pgvector, 33 MCP tools, 7 lifecycle hooks. Benchmarked 97.8% R@10 on Lo…

knowledge-memorypostgres

Zero-config MCP server for searchable documentation. Loads markdown into SQLite (default) or PostgreSQL with FTS5/tsvector keyword search and optional pgvector hybrid semantic search.

knowledge-memorypostgressqlite

Other use cases

Code Review Testing Security Git Workflows Documentation Debugging Performance Deployment & CI/CD API Development Refactoring Frontend Development Codebase Onboarding AI & Agent Development Mobile Development Observability & Monitoring Refactoring Frontend Development Codebase Onboarding