Database Management Agent Skills

Database Performance Patterns

Optimizes database query performance and prevents connection pool exhaustion using proven Postgres and Supabase patterns.

RLS Security Patterns

Implements robust Row-Level Security (RLS) policies for multi-tenant and user-scoped database architectures.

Database Function Lint Manager

Lints PostgreSQL functions, analyzes codebase usage, and generates actionable maintenance reports to ensure database integrity.

Supabase Migrations

Manages Supabase database schema changes, table creation, and Row Level Security policies using the Supabase CLI.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through advanced quantization, HNSW indexing, and efficient batch operations.

SQL & Relational Databases Mastery

Master production-grade SQL optimization, schema design, and database performance tuning for data engineering workflows.

ClickHouse Analytics & Patterns

Implements high-performance ClickHouse database schemas, optimized analytical queries, and efficient data engineering patterns for OLAP workloads.

Trading MCP Server Configuration

Configures Model Context Protocol (MCP) servers to integrate Claude Code with Alpaca trading APIs and local SQLite databases.

Crypto Trading Database Population

Populates trading databases with cryptocurrency symbols to ensure model availability and enable 24/7 market coverage.

SQL Writer for Game Analytics

Generates, validates, and executes Databricks SQL queries specifically for mobile game analytics and user behavior tracking.

AnomalyArmor Data Intelligence Ask

Queries database metadata and lineage using natural language to uncover table structures, PII, and data relationships.

Data Governance Tags

Classifies and governs database objects through automated tagging for security, compliance, and business organization.

Data Warehouse Architect

Architects robust data warehouses using star schemas, dimensional modeling, and enterprise SQL patterns for scalable analytics.

ClickHouse Analytics Patterns

Optimizes high-performance analytical workloads and data engineering using ClickHouse-specific design patterns and best practices.

SQL Guardrails

Enforces strict SQL standards and backend API patterns to prevent injection, data type mismatches, and contract violations.

Slow Query Analysis & DB Tuning

Analyzes database slow query logs to identify performance bottlenecks and provide actionable indexing and optimization strategies.

TikTok Supabase Data Sync

Synchronizes TikTok engagement data and readings from ClickHouse to Supabase to keep web content updated.

Data Architecture Patterns

Implements a type-safe, single-source-of-truth data architecture using TypeScript and Zod for centralized project and personal information.

Event Store Design & Implementation

Designs and implements robust, immutable event stores for event-sourced architectures and high-concurrency backend systems.

LoRAIro SQLAlchemy Repository Pattern

Implements type-safe SQLAlchemy repository patterns for consistent database operations and session management.

Enterprise ERP Consultant

Architects and implements complex business logic for enterprise resource planning systems including finance, inventory, and supply chain modules.

Database Migration & Schema Evolution

Manages complex database migrations across multiple ORMs with zero-downtime strategies and automated rollback procedures.

Flyway Database Migrations

Manages database schema changes and versioning through standardized Flyway migration patterns and PostgreSQL best practices.

jOOQ Database Patterns

Implements type-safe SQL queries and repository patterns using jOOQ for robust Kotlin and Java database interactions.

SQL Optimization Patterns

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

Prisma Development Specialist

Streamlines Prisma schema design, migrations, and database access patterns following production-grade architectural conventions.

AgentDB Performance Optimization

Optimizes AgentDB vector databases using quantization, HNSW indexing, and batch operations to achieve massive performance gains and memory reduction.

TypeORM Dev (Sellernote Conventions)

Develops TypeORM entities, migrations, and repository patterns using Sellernote-specific architectural conventions.

AgentDB Vector Search

Implements ultra-fast semantic vector search and HNSW indexing for RAG systems and intelligent document retrieval.

PostgreSQL Database Setup

Initializes PostgreSQL databases with standardized SQL schemas, Python setup scripts, and best-practice environment configurations.