Database Management Agent Skills

SQL Performance Optimization Patterns

Optimizes database performance through advanced SQL query patterns, strategic indexing, and detailed execution plan analysis.

Bknd Bulk Operations

Streamlines high-volume data operations in Bknd.io using optimized batch processing, chunking, and error handling strategies.

PostgreSQL Table Design

Designs high-performance, production-ready PostgreSQL schemas following industry best practices and modern database patterns.

SQL Optimization Patterns

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

Vanilla Rails Data Modeling

Enforces high-performance, multi-tenant database schema patterns and migrations for Ruby on Rails applications based on 37signals conventions.

Database Connection Pooler

Optimizes database connection pooling to enhance application performance and resource management efficiency.

SQL Data Analysis Expert

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

jOOQ Database Patterns

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

AgentDB Performance Optimization

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

Supabase Typed Query

Builds type-safe, functional Supabase queries using chainable APIs and entity-based CRUD patterns for robust database interactions.

Wasp Dev Server Manager

Orchestrates the Wasp development environment by managing local servers, database containers, and schema migrations.

TimescaleDB Expert

Optimizes time-series data management and PostgreSQL analytics through advanced hypertables, compression, and performance tuning.

Database Sharding Manager

Automates and guides the implementation of horizontal database sharding strategies to improve system performance and scalability.

Semantic RDF Modeling

Models software feature specifications and domain architectures using RDF ontologies and Turtle syntax.

Data Management Patterns

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

Rails Delegated Types Pattern

Implements a unified container model for complex Ruby on Rails content systems with 5 or more distinct types.

Supabase RLS Policy Expert

Generates and optimizes production-ready PostgreSQL row-level security (RLS) policies following Supabase best practices.

Supabase RLS Policy Expert

Generates production-ready, optimized PostgreSQL row-level security (RLS) policies for Supabase databases following security best practices.

F# Data Persistence Patterns

Implements robust data storage solutions using SQLite with Dapper, JSON files, or event sourcing patterns in F# projects.

Bknd Database Seeding

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

Bknd Relationship Designer

Defines and manages complex data relationships, foreign keys, and associations within the Bknd.io ecosystem.

Enterprise ERP Consultant

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

Database Documentation Generator

Automatically generates comprehensive database schema documentation, architecture guides, and operational runbooks using SQL and NoSQL CLI tools.

Postgres SQL Style Guide

Standardizes PostgreSQL development with comprehensive rules for naming conventions, schema design, and query formatting.

PostgreSQL Read-Only Explorer

Executes safe, read-only SQL queries and explores schemas across multiple PostgreSQL databases.

Database Migration Manager

Generates production-ready Supabase migrations with idempotent SQL, strict naming conventions, and advanced RLS security patterns.

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.

Database Schema

Enforces strict database schema conventions for Drizzle ORM and PostgreSQL to ensure consistent table structures, constraints, and indexing patterns.

Bknd Entity Field Manager

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