Database Management Agent Skills

PostgreSQL Database Setup

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

Airtable PM Data Model

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

Module Health Assessor

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

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.

Migration Helper

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

PocketBase Development

Provides comprehensive guidance and implementation patterns for building real-time backend services using the PocketBase open-source framework.

Database Architect & Optimizer

Designs, optimizes, and manages SQL and NoSQL databases using industry-standard best practices for performance and scalability.

PostgreSQL Database Setup

Standardizes PostgreSQL database initialization with automated schema generation, setup scripts, and high-performance connection drivers.

Rails Delegated Types Pattern

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

Vanilla Rails Models

Enforces production-grade Rails model patterns including state-as-records, namespaced concerns, and invocation-based method ordering.

Vanilla Rails Data Modeling

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

SQL Query Optimizer

Analyzes and optimizes SQL queries to improve performance by identifying bottlenecks and suggesting efficient indexing strategies.

Shiny Spatial Geospatial Database

Builds high-performance, dependency-free .NET geospatial applications using SQLite R*Tree indexing and custom C# geometry refinement.

Supabase RLS Policy Expert

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

PostgreSQL Table Design

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

ActiveRecord Patterns & Optimization

Optimizes database interactions by providing enterprise-grade ActiveRecord query patterns, association designs, and PostgreSQL-specific performance strategies.

Data Engineer Agent

Builds and maintains robust data pipelines, analytics infrastructure, and ETL processes with high data quality standards.

Databases & Architecture

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

Bazinga Database Operations

Manages concurrent-safe database operations for the BAZINGA multi-agent development system.

Convex Backend Development

Streamlines Convex backend development with standardized function syntax, schema definitions, and type-safe data modeling.

Database Design Architect

Architects production-grade SQL and NoSQL databases with automated schema validation and performance optimization patterns.

SQL Guardrails

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

JPA & Hibernate Patterns

Implements high-performance JPA and Hibernate design patterns for Spring Boot data layers.

Postgres Database Patterns

Optimizes PostgreSQL database design, query performance, and security through standardized implementation patterns and best practices.

Database Migrations

Implements safe, reversible database schema changes and zero-downtime deployment patterns for modern production environments.

ClickHouse Analytics & Engineering

Optimizes ClickHouse database schemas, queries, and data pipelines for high-performance analytical workloads.

Mattermost Schema Migration Reviewer

Analyzes SQL migrations against Mattermost best practices to ensure safe, zero-downtime database updates.

Yammm Schema DSL

Architects and validates typed data schemas using the Yammm domain-specific language for robust data modeling.

Etendo Database Manager

Manages Etendo Application Dictionary structures by creating and modifying tables, columns, views, and references via webhooks.