Database Management Agent Skills

Query Writer

Generates and maintains standardized BigQuery SQL and Python ETL scripts following Mozilla's data engineering conventions and partitioning patterns.

BigQuery ETL Core

Establishes foundational project structures, naming conventions, and privacy standards for managing large-scale BigQuery ETL workflows.

Understanding Data

Performs systematic data profiling and exploratory analysis to reveal the structure, quality, and relationships within relational databases.

InstantDB

Provides expert guidance and best practices for building, debugging, and querying with the InstantDB real-time database.

PostGIS Geospatial Development

Implements best practices for querying and managing geospatial data in PostgreSQL with PostGIS.

Elasticsearch & OpenSearch

Integrates Elasticsearch and OpenSearch for complex search queries, data aggregations, and comprehensive index management.

PostgreSQL Database Manager

Manages PostgreSQL database connections and executes secure SQL queries with automated schema introspection and result formatting.

Redis Cache Management

Manages Redis cache operations including key-value manipulation, production-safe pattern searching, and TTL inspection.

Supabase Database Integration

Query and interact with Supabase databases using real-time subscriptions and PostgreSQL-compatible syntax while respecting Row Level Security policies.

Backend Models

Architects robust database models following Eloquent best practices, including relationship definitions, data typing, and multi-layer validation.

Database Operations

Streamlines database interactions by providing standardized patterns for CRUD operations, session management, and performance optimization.

Alembic Migration Manager

Manages database schema and data migrations using Alembic through standardized workflows and production-ready best practices.

SQL Query Optimization

Optimizes PostgreSQL database performance through structured analysis, index recommendations, and advanced query refactoring patterns.

Database Operations

Implements high-performance, production-ready database architectures using async patterns and modern ORM best practices.

Backend Models

Defines and structures database schemas with robust naming conventions, data integrity constraints, and optimized relationship mappings.

SurrealDB for Dart

Integrates SurrealDB into Dart and Flutter applications with support for embedded databases, ORM features, and AI-powered vector search.

Backend Migrations

Manages database schema changes and data migrations using industry best practices to ensure data integrity and zero-downtime deployments.

Writing Queries

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

Metadata Manager

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

Model Requirements Gatherer

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

Backend Queries

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

Backend Migrations

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

dbt Model Builder

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

Data Quality Test Generator

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

Backend Queries

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

Backend Models

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

Backend Models

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

Backend Queries

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

Backend Migrations

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

PostgreSQL Schema Design Expert

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