Databases Agent Skills

MUST use when writing MySQL queries.

Build read models and projections from event streams.

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Implements optimized Spring Boot data persistence layers using expert JPA and Hibernate implementation patterns.

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

Use when deploying a database to Zeabur.

Guides and best practices for working with Neon Serverless Postgres.

Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies.

Parses, edits, and generates A5:SQL Mk-2 ER diagram (.a5er) files safely while maintaining formatting integrity and reference consistency.

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.

Optional advanced tool for complex data modeling.

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

Use this skill when a read model genuinely needs an IReducerFor<T> — when model-bound projection attributes and fluent IProjectionFor<T>…

JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in…

JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and…

Redis data structure patterns, caching strategies, distributed locks, rate limiting, pub/sub, and connection management for production…

Airtable API integration with managed OAuth.

Implement database sharding for horizontal scalability.

Implement event sourcing and CQRS patterns using event stores, aggregates, and projections.

Analyze and optimize SQL queries for performance.