Database Management Agent Skills

Database Integrity & Validation Engine

Ensures database reliability by automatically implementing data types, ranges, and referential integrity constraints using a specialized validation engine.

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for scalability in databases like MongoDB and DynamoDB.

ORM & Database Schema Generator

Generates production-ready ORM models and database schemas for frameworks like TypeORM, Prisma, and SQLAlchemy using natural language.

Database Query Performance Optimizer

Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks.

SQL Query Optimizer

Analyzes and refines SQL queries to enhance database performance through index recommendations and structural rewrites.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for major SQL databases to optimize performance and enforce business logic.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-efficiency table design, advanced query patterns, and real-time analytics best practices.

Database Design & Architecture

Architects optimized database schemas and selects the ideal data stack based on specific project requirements and performance needs.

NoSQL Database Architect

Architects high-scale distributed database schemas for Cassandra and DynamoDB using query-first modeling and performance-optimized patterns.

AgentDB Advanced Features

Implements high-performance vector search, distributed QUIC synchronization, and multi-database management for advanced AI systems.

Database Design Architect

Optimizes database architecture by providing expert guidance on schema design, ORM selection, and performance indexing.

Database Design & Strategy

Architects high-performance database schemas and provides strategic guidance on database and ORM selection.

Kysely SQL Database

Simplifies SQL database management using the Kysely type-safe query builder for Expo and Bun environments.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-performance schema design, analytical query patterns, and efficient data engineering practices.

ClickHouse Analytics & Data Engineering

Optimizes high-performance analytical workloads using specialized ClickHouse query patterns, table engines, and data engineering best practices.

NoSQL Expert Design Patterns

Architects high-performance distributed database schemas using query-first modeling and single-table design patterns for Cassandra and DynamoDB.

Rails Migrations

Streamlines database schema management and ActiveRecord migration workflows for Ruby on Rails applications.

ActiveRecord for Rails

Manages and optimizes Ruby on Rails database interactions through expert ActiveRecord guidance and implementation patterns.

NoSQL Expert Patterns

Optimizes distributed database architecture for Cassandra and DynamoDB using query-first modeling and high-scale design patterns.

Database Migration Mastery

Executes complex database migrations and schema transformations across multiple ORMs with a focus on zero-downtime and data integrity.

SQL Optimization Patterns

Optimizes database performance through advanced query tuning, indexing strategies, and detailed execution plan analysis.

Backend Queries

Constructs optimized and secure database queries using parameterized statements, eager loading, and efficient indexing strategies.

Firebase Backend Suite

Implements scalable serverless backend services including Firestore, Authentication, and Cloud Functions using production-grade security patterns.

T-SQL Pro & Database Optimization

Writes high-performance, secure T-SQL code and optimizes SQL Server database schemas using industry best practices.

MySQL Database Skill

Executes safe SELECT queries against MySQL and MariaDB databases with built-in connection pooling and SQL injection prevention.

SQL Expert & Data Modeling

Optimizes database performance through advanced query tuning, strategic indexing, and production-grade data modeling.

SQL Batching

Prevents D1/SQLite 'too many SQL variables' errors by automatically batching Drizzle ORM queries with dynamic arrays.

SQL Optimization Patterns

Optimizes SQL database performance through query plan analysis, advanced indexing strategies, and systematic query refactoring.

AgentDB Vector Search

Implements high-performance semantic vector search and document retrieval with sub-millisecond latency for intelligent RAG systems.

Unified SQL Data Analyst

Queries and joins data across PostgreSQL, MySQL, and SQLite databases using a unified SQL engine for advanced data exploration.