Database Management Agent Skills

T-SQL Functions Master

Provides a comprehensive reference and implementation patterns for T-SQL functions across SQL Server and Azure SQL Database versions.

T-SQL Query Optimization

Optimizes SQL Server and Azure SQL Database performance through advanced T-SQL query tuning and execution plan analysis.

Azure SQL Optimization

Optimizes Azure SQL Database performance through platform-specific configurations, monitoring scripts, and scaling strategies.

CQRS and Event Sourcing

Implements scalable architectural patterns for separated read/write models and immutable event logs to ensure system auditability.

CQRS & Event Sourcing Architect

Implements scalable, auditable system architectures using Command Query Responsibility Segregation and Event Sourcing patterns.

Convex Actions and General Development

Streamlines the development of robust Convex backends through advanced action implementation, HTTP routing, schema validation, and task scheduling.

Convex Mutations

Implements and manages Convex mutation functions with best practices for database operations, validation, and task scheduling.

Database Optimizer

Optimizes database performance through query tuning, strategic indexing, and execution plan analysis for PostgreSQL and MySQL.

PostgreSQL Pro

Optimizes PostgreSQL performance, manages complex database administration tasks, and implements advanced indexing and replication strategies.

Database Schema Designer

Architects robust data models for SQL and NoSQL databases using industry-standard normalization, indexing strategies, and migration patterns.

Query Expert

Generates, optimizes, and troubleshoots database queries across multiple SQL and NoSQL systems to ensure peak performance and scalability.

SurrealDB Expert

Architects, optimizes, and secures SurrealDB applications using multi-model database patterns and real-time capabilities.

Database Migration Strategy

Executes complex database migrations and schema transformations using zero-downtime strategies and cross-ORM best practices.

Project Schema & Terminology Designer

Establishes a unified project language and robust data structures to ensure consistency across AI-native development workflows.

Backend Queries

Writes secure, performant database queries and data access logic using optimization techniques and security best practices.

Backend Migrations

Manages database schema changes through version-controlled migration files while ensuring rollback safety and zero-downtime compatibility.

Backend Models

Defines and optimizes database models with appropriate data types, relationships, and integrity constraints across various ORM frameworks.

Logseq DB Knowledge

Provides comprehensive guidance on working with Logseq's database-based data model, covering nodes, typed properties, classes, and advanced Datalog queries.

C# Database Access Patterns

Streamlines RDBMS integration in C# for PostgreSQL, MySQL, DuckDB, and legacy systems using optimized access patterns and drivers.

ActiveRecord

Streamlines Ruby on Rails database management with expert patterns for migrations, associations, and query optimization.

TimescaleDB Time-Series Optimization

Optimizes time-series data management by enforcing TimescaleDB 2.24.0 best practices for hypertables, continuous aggregates, and compression.

PostgreSQL 18 Architecture

Enforces PostgreSQL 18 best practices for schema design, migrations, and high-performance database architecture.

Doctrine Elegant Entity Generator

Generates Doctrine entities and repositories following Elegant Objects principles for robust, maintainable PHP code.

Smoke Test Database

Validates database connectivity, performance SLAs, schema integrity, and backup readiness during software release workflows.

Typedown Expert

Transforms unstructured Markdown documentation into rigorous, machine-verifiable data schemas using Pydantic models and YAML entities.

PostGIS Spatial Database

Enforces PostGIS 3.6.1 best practices for managing complex geographic data, spatial queries, and advanced geometry operations.

AI Agent Property Manager

Automates the multi-step process of adding new comparison properties to the AI coding agents matrix across data files, UI components, and GitHub templates.

Kysely SQL Converter

Converts raw SQL queries into type-safe Kysely TypeScript code to streamline database layer development.

Neo4j Graph Developer

Streamlines Neo4j development by providing automated data modeling, Cypher query optimization, and schema visualization tools.

Database Design Patterns

Optimizes database architectures through expert schema design, query tuning, and scalable persistence patterns for SQL and NoSQL environments.