Databases Agent Skills

Expert in vector databases, embedding strategies, and semantic search implementation.

LispSyntax.jl ↔ ACSets.jl bidirectional bridge with OCaml ppx_sexp_conv-style deriving

Detects unrelated schema.rb changes in PRs by cross-referencing against included migrations.

SQLite disaster recovery and streaming replication to cloud storage (S3, GCS, Azure, SFTP, NATS).

Migrates mock data from Drizzle ORM schemas to C# MockData classes

Manage local multigres cluster components (multipooler, pgctld, multiorch, multigateway) - start/stop services, view logs, connect with…

Azure Cosmos DB SDK for Java. NoSQL database operations with global distribution, multi-model support, and reactive patterns. Triggers…

Azure Cosmos DB SDK for Rust (NoSQL API).

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.

Azure MySQL Flexible Server SDK for .NET.

Azure PostgreSQL Flexible Server SDK for .NET.

Generates SQL validation notebooks for dbt PR changes with before/after comparison queries.

Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.

Postgres performance optimization and best practices from Supabase.

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies.

Design and implement event stores for event-sourced systems.

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Build read models and projections from event streams.

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

Data synchronization, ETL patterns, and data management for MaintainX.

PostgreSQL and SQLite database administration for Rails apps.