Database Management Agent Skills

SQLModel ORM Helper

Designs and implements production-grade database layers for Python applications using SQLModel and SQLAlchemy 2.0 patterns.

Beanie ODM for MongoDB

Simplifies MongoDB integration in FastAPI applications using Beanie ODM for asynchronous document mapping and advanced query patterns.

OpenAPI & Connector Database Manager

Queries and manages integrated connector configurations and API metadata within the v3_openapi database.

Supabase Database Expert

Architects, queries, and manages production-grade Supabase environments with PostgreSQL, Row Level Security, and Edge Functions.

Blacklake OpenAPI Database Query

Queries and manages integrated connectors and API configurations within the v3_openapi database using structured SQL templates.

Datarails Data Query

Queries Datarails Finance OS tables using filters, samples, and custom SQL-like expressions to investigate financial data.

Datarails Finance OS Table Discovery

Explores and catalogs Datarails Finance OS tables to discover data structures, schemas, and field distributions.

Database Tenant & Org Manager

Queries and manages tenant, organization, and factory information within the v3_user database using structured SQL execution.

Aegis Tenancy Enforcer

Enforces strict multi-tenant data isolation by ensuring mandatory communityId filters across all MongoDB operations and service logic.

Hostinger VPS Database Manager

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

InstantDB

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

Convex Component Authoring

Builds and publishes reusable, modular Convex components with isolated database schemas and type-safe functions.

Class Diagram Analyst

Generates precise Class Diagrams in Mermaid and YAML formats for PayloadCMS and MongoDB architectures based on existing design documents.

Convex Component Authoring

Builds and structures reusable, isolated Convex components for efficient backend development and logic sharing.

Convex Component Authoring

Simplifies the creation of reusable, isolated Convex backend components for modular database logic and shared functions.

Convex Component Authoring

Architects and implements modular, reusable backend components with isolated schemas and type-safe functions for the Convex platform.

Database Migration Patterns

Manages database schema evolution using Supabase, Prisma, and Drizzle with production-safe patterns.

Data Lake Architect

Designs scalable data lake and lakehouse architectures using optimized partitioning, storage tiers, and high-performance formats like Iceberg and Parquet.

SQLModel Task Data Modeling

Architects robust, type-safe, and asynchronous database schemas for task-based applications using SQLModel and PostgreSQL.

SQL Performance Optimizer

Optimizes SQL query performance by applying proven patterns for indexing, JOIN structures, and execution plan analysis.

DataFusion Query Advisor

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

InterSystems IRIS DTL Transformations

Guides the development, testing, and implementation of Data Transformation Language (DTL) for InterSystems IRIS interoperability productions.

Rust Parquet Optimization

Optimizes Parquet file operations in Rust to improve query performance, reduce storage costs, and prevent memory issues.

Drizzle ORM Workflow Manager

Manages Drizzle ORM and drizzle-kit workflows including migrations, schema generation, and specialized database reset flows.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies to maximize search speed and minimize memory usage.

Understanding Data

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

BigQuery ETL Core

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

Hoardinator Session Ingest

Automates the synchronization of local Claude Code session transcripts to a Supabase database for centralized tracking and analysis.

PostgreSQL Optimization & Patterns

Provides production-ready PostgreSQL patterns for query optimization, schema design, and database security based on Supabase best practices.

AgentDB Advanced Features

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