Database Management Agent Skills

MS SQL Server Script Writer for Windmill

Generates optimized MS SQL Server queries for the Windmill platform with standardized parameter handling and deployment metadata.

Phoenix Ecto Best Practices

Implements industry-standard patterns for Ecto schemas, changesets, and database migrations in Elixir applications.

Windmill MySQL Script Writer

Generates Windmill-compatible MySQL scripts with standardized parameterization and metadata workflows.

Windmill DuckDB Script Writer

Generates and deploys optimized DuckDB scripts for the Windmill platform featuring external database and S3 integration.

Snowflake Scripting for Windmill

Streamlines the creation, parameterization, and deployment of Snowflake SQL scripts within the Windmill automation platform.

Holochain DNA Development (Nondominium)

Develops ValueFlows-compliant Holochain DNA with a focus on integrity/coordinator architecture and WASM optimization.

Database Cache Layer

Implements high-performance multi-tier caching architectures to reduce database load and minimize query latency.

InsForge Database Schema Patterns

Provides optimized PostgreSQL schema templates and Row Level Security (RLS) policies for InsForge and PostgREST backends.

Database Backup Automator

Automates database backup scheduling, encryption, and recovery procedures across multiple SQL and NoSQL engines.

Database Recovery Manager

Automates database disaster recovery, point-in-time recovery, and failover strategies to ensure high availability and data resilience.

Database Documentation Generator

Generates comprehensive database documentation, ERD diagrams, and data dictionaries directly from existing schemas.

Data Validation Engine

Automates the implementation of database integrity constraints, data type validation, and business rules across multiple database environments.

SQL Optimization Patterns

Optimizes SQL queries and database performance through indexing strategies, EXPLAIN plan analysis, and efficient query patterns.

Database Sharding Manager

Designs and implements horizontal database sharding strategies to scale data architecture across multiple server instances.

Database Migration Manager

Manages database schema evolution through automated, version-controlled migrations for SQL and NoSQL databases.

FairDB Backup Manager

Manages automated PostgreSQL backups and point-in-time restorations for FairDB databases using pgBackRest and Wasabi S3 storage.

ORM Code Generator

Generates production-ready ORM models and database schemas across multiple frameworks and languages from natural language descriptions.

Database Migration Manager

Automates the creation, application, and rollback of version-controlled database migrations across SQL and NoSQL environments.

Data SQL Optimization & Modeling

Optimizes SQL queries and database schemas using industry-standard patterns for performance, maintainability, and scalability.

TimescaleDB Hypertable Setup

Guides the design and implementation of optimized TimescaleDB hypertables, compression policies, and continuous aggregates for high-performance time-series data.

Database Migration & Schema Management

Executes seamless database schema and data migrations across multiple ORMs with robust rollback and zero-downtime strategies.

Database Architect & Schema Designer

Guides architectural decisions for database selection, schema modeling, and performance optimization.

NoSQL Expert Patterns

Guides the architecture and optimization of high-scale distributed databases like Cassandra and DynamoDB using query-first modeling.

Database Design & Optimization

Architects scalable database schemas and optimizes query performance through intelligent decision-making and best practices.

Database Design & Architecture

Architects scalable, performant database schemas and selects optimal data persistence tools based on specific project requirements.

NoSQL Design Expert

Architects high-scale distributed database systems using query-first modeling and single-table design patterns for Cassandra and DynamoDB.

NoSQL Expert & Distributed Systems Architect

Provides expert guidance and architectural patterns for high-scale distributed NoSQL databases like Cassandra and DynamoDB.

CloudBase Document Database Web SDK

Provides standardized implementation patterns and guidance for managing CloudBase document databases in web applications.

Neon Postgres Patterns

Implements expert patterns for Neon serverless Postgres, including database branching, connection pooling, and ORM integrations.

Neon Postgres

Implements expert patterns for Neon serverless Postgres, including database branching, connection pooling, and Prisma or Drizzle ORM integrations.