Database Management Agent Skills

Convex Actions and General Development

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

Azure SQL Optimization

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

Advanced T-SQL Patterns

Implements complex SQL Server techniques including recursive CTEs, temporal tables, and memory-optimized operations.

SQL Server 2025 & SqlPackage Support

Enables advanced SQL Server 2025 capabilities including native vector database support, AI model integration, and modernized deployment workflows.

CQRS and Event Sourcing

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

Database Architect & Drizzle ORM Specialist

Architects normalized PostgreSQL schemas and implements type-safe Drizzle ORM models with industry-standard best practices.

CQRS & Event Sourcing Architect

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

Convex Mutations

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

Database Design Patterns

Architects scalable database schemas and optimizes query performance across relational and NoSQL systems.

Database Schema Designer

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

Logseq DB Knowledge

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

Backend Models

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

Backend Migrations

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

Backend Queries

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

Project Schema & Terminology Designer

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

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.

PostgreSQL 18 Architecture

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

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.

TimescaleDB Time-Series Optimization

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

PostGIS Spatial Database

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

Typedown Expert

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

ActiveRecord

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

Doctrine Elegant Entity Generator

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

C# Database Access Patterns

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

Smoke Test Database

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

SQL Design Patterns

Provides a comprehensive reference for advanced SQL syntax, optimization strategies, and common query implementation patterns.

Database Management & Schema Optimization

Manages database schemas, migrations, and performance optimizations using Drizzle ORM and Neon Postgres.

Kysely Query Converter

Transforms raw SQL queries into type-safe Kysely TypeScript code for streamlined database management.