Database Management Agent Skills

Supabase Migrations

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

SQLite Performance & Best Practices

Configures Claude to implement high-performance SQLite patterns including optimized PRAGMA settings, strict typing, and efficient bulk data loading.

Database Migration Manager

Manages database schema evolution by generating and executing version-controlled migrations for PostgreSQL, MySQL, SQLite, and MongoDB.

PostgreSQL Scaling & Performance

Implements advanced PostgreSQL scaling strategies including partitioning, connection pooling, and high-availability replication.

Bknd Advanced Query Filtering

Enables advanced data retrieval in Bknd.io projects using complex filter conditions and logical operators.

TikTok Supabase Data Sync

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

AgentDB Advanced Features

Powers distributed AI systems with low-latency QUIC synchronization, hybrid vector search, and multi-database management.

Data Architecture Patterns

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

Database Architect & Management

Designs, optimizes, and manages relational and NoSQL databases using industry-standard patterns and performance-tuning techniques.

PostGIS Geospatial Architecture

Implements advanced geospatial features including geofencing, spatial indexing, and real-time fleet tracking using PostGIS and PGRouting.

Airtable PM Data Model

Provides a standardized data model reference for orchestrating Product Management workflows and requirements within Airtable.

Architecture Performance Optimizer

Analyzes and resolves performance bottlenecks across database queries, API endpoints, and frontend rendering frameworks.

Module Health Assessor

Analyzes and optimizes modular architecture health for Logseq Template Graphs by evaluating balance, cohesion, and dependencies.

Database Diff & Migration Adapter

Compares database schemas and generates transaction-safe migration scripts and rollback procedures for PostgreSQL and MySQL.

SQL Query & Schema Design

Provides expert SQL patterns for complex database querying, efficient schema design, and performance optimization.

AgentDB Performance Optimization

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

Row-Level Security Patterns

Implements robust database row-level security policies for multi-tenant and user-scoped data architectures.

Databases & Architecture

Design and implement scalable database schemas, system architectures, and robust APIs for modern software applications.

Database Management

Architects, optimizes, and manages relational and NoSQL databases to ensure high performance, data integrity, and scalability.

Database Migration & Schema Evolution

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

Database Assistant

Expertly designs database schemas, optimizes complex SQL queries, and manages data migrations with industry-leading best practices.

LoRAIro SQLAlchemy Repository Pattern

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

Supabase Implementation Expert

Provides production-grade Supabase implementation, security auditing, and performance optimization for modern web applications.

Logseq DB Migration Expert

Guides the transition of Logseq knowledge bases from Markdown files to the advanced SQLite database architecture.

PostgreSQL Expert

Streamlines PostgreSQL development with expert guidance on SQL optimization, database design, and systems administration.

Migration Helper

Facilitates safe database and code migrations using zero-downtime strategies and proven implementation patterns.

PostgreSQL Streaming Replication Manager

Automates the configuration, monitoring, and failover management of PostgreSQL streaming replication clusters.

PostgreSQL PL/pgSQL Development

Develops robust PostgreSQL procedural logic including functions, triggers, and procedures with production-ready patterns.

Supabase Migrations & Schema Management

Manages Supabase database schemas and migrations through automated CLI commands and best-practice SQL patterns.

Database Stored Procedure Generator

Generates production-grade stored procedures, functions, and triggers across major SQL databases to streamline complex backend logic and data integrity.