Database Management Agent Skills

NestJS TypeORM Integration

Integrates TypeORM into NestJS projects by configuring data sources, defining entities, managing migrations, and implementing scalable repository patterns.

Database Schema

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

Wasp Dev Server Manager

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

Logseq Database Schema Expert

Explains Logseq's Datascript database architecture, including entity relationships, built-in classes, and property type systems.

Logseq Datalog Expert

Builds and optimizes complex Datalog queries for Logseq's database-driven graphs.

Database Management & Optimization

Simplifies database schema design, query optimization, and administration for MongoDB and PostgreSQL environments.

Domain-Driven Design Modeling

Models complex business logic using Domain-Driven Design patterns like Entities, Value Objects, and Aggregates.

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 Setup & Management

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

Databases & Architecture

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

Database Assistant

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

Prisma Database Patterns

Implements production-ready Prisma ORM patterns for database schema design, migrations, and high-performance queries.

Recce dbt Data Validation

Automates data validation and impact analysis for dbt projects using the Recce framework.

dbt Development

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

ActiveRecord Patterns & Optimization

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

PostgreSQL Table Design

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

Supabase RLS Policy Expert

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

SQL Query Optimizer

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

Vanilla Rails Data Modeling

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

Vanilla Rails Models

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

Rails Delegated Types Pattern

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

PostgreSQL Database Setup

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

Database Architect & Optimizer

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

Migration Helper

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

Logseq DB Migration Expert

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

Supabase Implementation Expert

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

Module Health Assessor

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

Airtable PM Data Model

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

PostgreSQL Database Setup

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