Database Management Agent Skills

PostgreSQL Schema Design Expert

Architects high-performance PostgreSQL databases using industry-standard schema design, indexing strategies, and data integrity patterns.

Backend Migrations

Manages database schema evolutions and data migrations using industry-standard tools and zero-downtime best practices.

Backend Queries

Writes efficient, secure database queries while preventing N+1 problems and SQL injection vulnerabilities.

Backend Models

Defines robust database models and schemas with precise ORM mappings, relationships, and data integrity constraints.

Backend Models

Manages database model configurations, relationships, and validation logic to ensure robust data structures and ORM integrity.

Backend Queries

Optimizes database performance and security through efficient query construction, transaction management, and eager loading patterns.

pgdbm Database Pattern Selector

Guides developers in selecting the optimal architectural pattern for PostgreSQL database management based on deployment context and reusability.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance using quantization, HNSW indexing, and advanced caching strategies to reduce memory footprint and accelerate search speeds.

AgentDB Advanced Features

Implement high-performance distributed vector databases with sub-millisecond synchronization, hybrid search, and advanced distance metrics.

SQL Development

Writes, reviews, and optimizes performant SQL queries while applying PostgreSQL-specific best practices for schema design and performance tuning.

Task Search

Implements robust search capabilities for task management applications, including keyword matching, relevance ranking, and multi-criteria filtering.

Backend Migrations

Manages database schema changes through reversible, version-controlled migration files while ensuring zero-downtime deployment compatibility.

Hostinger VPS Database Manager

Manages shared PostgreSQL, Redis, and MongoDB instances on Hostinger VPS infrastructure via Docker commands.

Data Quality Test Generator

Generates comprehensive dbt test suites using modern 1.10+ syntax to ensure data integrity and structural consistency across analytical models.

dbt Model Builder

Constructs standardized dbt models following Kimball dimensional patterns and modern testing configurations.

Backend Migrations

Manages PostgreSQL schema changes and Prisma database migrations following a split-architecture pattern and strict coding standards.

Backend Queries

Implements structured database queries and repository patterns using Prisma ORM to maintain a robust layered architecture.

Database Management & Design

Optimizes database performance and manages schema design, migrations, and complex SQL query generation for relational databases.

Model Requirements Gatherer

Guides the structured gathering of requirements for new and existing BigQuery data models to ensure robust ETL pipeline planning.

Metadata Manager

Streamlines the creation and management of BigQuery table schemas, metadata configurations, and Airflow DAG schedules following Mozilla ETL conventions.

Mozilla BigQuery Query Writer

Writes cost-optimized, high-performance BigQuery queries for Mozilla telemetry and Firefox metrics.

SQLite for Go Development

Implements high-performance SQLite patterns in Go applications using best practices for drivers, migrations, and concurrency.

Database Migration Expert

Executes seamless database schema transitions and data transformations across multiple ORMs with zero-downtime and rollback strategies.

SQL Optimization Patterns

Optimizes SQL query performance through systematic indexing strategies, execution plan analysis, and efficient query patterns.

DataFusion Query Advisor

Optimizes Apache DataFusion SQL queries and DataFrame operations through advanced performance analysis and best practices.

OP Database Metadata Manager

Provides specialized SQL query templates for managing and exploring v3_metadata database structures, including business objects and custom fields.

Drizzle Cube Joins

Configures and manages complex relational joins between data cubes to enable seamless, secure cross-cube querying in Drizzle Cube.

Drizzle Cube Definition

Defines type-safe semantic layer cubes using Drizzle ORM for multi-tenant analytics and business logic abstraction.

Writing Queries

Guides the systematic development, verification, and documentation of SQL queries for analytical data processing.

SQL Optimization Patterns

Optimizes database performance through advanced indexing, EXPLAIN plan analysis, and efficient query implementation patterns.