Databases Agent Skills

When to activate: PostgreSQL, JSONB, pg, psql, indexes, CTEs, window functions, partitioning, VACUUM, pg_stat, postgres

When to activate: Prisma ORM, schema.prisma, migrations, Prisma Client, relations, transactions, raw queries, seeding

When to activate: Redis, cache, pub/sub, streams, Lua, cluster, persistence, rate limiting, session store, queue

When to activate: SQLAlchemy 2.0, ORM, async sessions, relationships, query optimization, migrations

Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and…

Optimize AgentDB performance with quantization (4-32x memory reduction), HNSW indexing (150x faster search), caching, and batch operations.

Implement semantic vector search with AgentDB for intelligent document retrieval, similarity matching, and context-aware querying.

Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications

Database schema design, migrations, query optimization with SQL, Exposed ORM, Flyway.

Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures.

Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL…

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow…

Step-by-step instructions for designing table schemas and setting up TimescaleDB with hypertables, indexes, compression, retention…

Manages and edits MicroOLAP Database Designer (.pdd) files for PostgreSQL data modeling and schema management.

Migrate an existing Meltano extractor or Singer tap workflow to a Fivetran Connector SDK connector.

This skill should be used when wiki-curator needs to upgrade a vault's schema_version to match the current plugin version.

Review database migration files when a change adds or modifies paths under migrations/.

This skill enables Claude to design NoSQL data models.

Manages MongoDB Atlas Stream Processing (ASP) workflows.

Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language.

Interact with a MongoDB database for persistent document storage.