Database Management Agent Skills

Supabase Realtime Specialist

Implements live data synchronization, presence tracking, and real-time notifications using Supabase Realtime.

Database Migration Manager

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

Architecture Performance Optimizer

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

Database Stored Procedure Generator

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

SaaS Production Templates

Generates production-ready boilerplate for Supabase authentication, environment validation, and core Next.js layouts.

Supabase PostgreSQL Functions

Generates secure, production-ready PostgreSQL functions and triggers optimized for Supabase databases.

Module Health Assessor

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

Slow Query Analysis & DB Tuning

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

Database Performance & Anti-Patterns

Identifies and remediates common database performance bottlenecks like N+1 queries, unbounded fetches, and connection pool issues.

SQL Data Analysis Expert

Performs advanced SQL data analysis, query optimization, and complex transformations using modern database patterns.

Frappe DocType Builder

Constructs complete DocType definitions for the Frappe Framework, including fields, permissions, and configurations.

Supabase Setup & Management

Configures and secures Supabase backends including database schemas, RLS policies, authentication providers, and Edge Functions.

dbt Development

Validates dbt models against standardized coding conventions to ensure consistent naming, SQL structure, testing coverage, and documentation.

Neo4j Cypher Graph Expert

Integrates Neo4j graph databases with Claude to execute Cypher queries, manage schemas, and explore complex data relationships.

Row-Level Security Patterns

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

Supabase Migrations & Schema Management

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

Data Management Patterns

Provides standardized patterns for zero-downtime migrations, automated backups, data retention policies, and GDPR compliance workflows.

SQLite Performance & Best Practices

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

Convex Backend Development

Streamlines the implementation of Convex backend features using Zod validation, custom function wrappers, and type-safe database interactions.

Mongoose MongoDB Integration

Simplifies MongoDB database interactions using the Mongoose ODM for schema modeling and advanced querying.

Data Management Patterns

Implements robust database strategies for zero-downtime migrations, automated backups, and regulatory data compliance.

Unified Database Management

Manages both MongoDB and PostgreSQL environments, from schema design and query optimization to production administration and migrations.

Supabase RLS Policy Generator

Generates secure, production-ready Row Level Security policies for Supabase tables with support for complex account architectures and admin bypass.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers across multiple database systems to automate complex backend logic.

ClickHouse Query & Schema Optimizer

Optimizes ClickHouse database performance through expert schema design, primary key ordering, and query tuning.

Database Migration Manager

Manages database schema evolution by generating and applying version-controlled migration scripts for major SQL and NoSQL databases.

Bknd Database Seeding

Populates Bknd databases with initial, test, and development data using standardized seeding patterns and idempotent logic.

Bknd Entity Deletion

Removes database entities safely from Bknd.io by managing relationship dependencies, data backups, and destructive schema synchronization.

Bknd CRUD Read & Querying

Retrieves and queries data from Bknd database entities using the SDK or REST API with advanced filtering and relation support.

Bknd Entity Field Manager

Streamlines the process of adding and configuring data fields within Bknd entities using both UI-based and code-first approaches.