MySQL plugins

Design and optimize database schemas, SQL queries, and data architectures across PostgreSQL, MySQL, MongoDB, and cloud data warehouses with expert guidance on indexing, constraints, and performance tuning for production systems. Handles greenfield schema design and re-architecture projects.

Automate database migrations with zero-downtime SQL scripts, observability via CDC pipelines and Grafana, and expert DBA agents for multi-cloud operations, performance tuning, and reliability engineering across PostgreSQL, MySQL, MongoDB, and more.

Optimize database performance and cloud infrastructure costs across AWS, Azure, and GCP. Design scalable data layers, tune SQL/NoSQL queries, and implement cost-effective cloud architectures.

Generate SQL queries from natural language and perform cohort analysis on user engagement data with retention curves, churn patterns, and statistical A/B testing with ship/extend/stop recommendations.

Analyze and optimize SQL query performance, indexing strategies, and execution plans across MySQL, PostgreSQL, SQL Server, and Oracle — tune pagination, batch operations, and pinpoint bottlenecks.

Reviews SQL code for security vulnerabilities, performance issues, and maintainability across MySQL, PostgreSQL, SQL Server, and Oracle databases.

Analyze SQL queries for performance bottlenecks and automatically rewrite slow queries with execution plan analysis, anti-pattern detection, and database-specific optimizations for PostgreSQL and MySQL

Design and visualize normalized relational database schemas for PostgreSQL and MySQL from requirements, including ERD generation via Mermaid, DDL, constraints, indexes, relationships, and migration scripts.

Query SQL databases and tabular files (CSV, Excel, JSON) using SLQ or native SQL via the sq CLI, with support for cross-source joins, output formatting, and data inspection/diff commands.

Generate Markdown documentation for PostgreSQL, MySQL, and MongoDB databases by introspecting schemas, including tables, columns, relationships, indexes, constraints, views, procedures, and ERD diagrams.

Analyze PostgreSQL and MySQL index usage to detect missing indexes causing sequential scans, identify unused indexes, and generate SQL scripts for optimal index configuration with impact analysis

Scan PostgreSQL, MySQL, and MongoDB databases for 50+ security vulnerabilities including weak passwords, excessive permissions, and SQL injection vectors, then generate OWASP compliance reports and automated remediation scripts.

Archive historical database records to reduce primary table size by 50-90% by moving old data to archive tables or cold storage (S3, Azure Blob, GCS) with automated retention policies, compression, and compliance tracking.

Analyze slow database queries across PostgreSQL, MySQL, and MongoDB by interpreting EXPLAIN plans, buffer stats, and index usage to detect bottlenecks like sequential scans, missing indexes, and inefficient joins, and receive specific optimization recommendations with expected impact.

Compare PostgreSQL and MySQL database schemas across environments, detect differences in tables, columns, indexes, constraints, and triggers, and generate safe migration scripts with rollback capabilities.

Manage large database tables by implementing range, list, hash, and composite partitioning strategies for PostgreSQL and MySQL, with automated partition maintenance and query optimization.

Analyze product data end-to-end: build north-star metric trees, explain and optimize SQL, spec dashboards and data pipelines, audit dataset quality, extract chart data from images, and read out A/B test results with statistical significance and ship recommendations.

Audits PostgreSQL and MySQL databases for data integrity issues (NULLs, orphans, format violations, duplicates) and automatically generates CHECK constraints, foreign keys, and triggers to enforce quality rules across database and application layers.

Implement backup strategies for databases, filesystems, and cloud resources with automated scheduling, retention policies, encryption, verification, and disaster recovery. Generate production-ready configuration code for multi-platform infrastructure.

Generate production-ready backup scripts for PostgreSQL, MySQL, MongoDB, and SQLite with scheduling, compression, encryption, and retention policies, plus restore procedures. Automates disaster recovery workflows directly from Claude Code. Supports multiple databases and custom scheduling.

Generate ORM models, migrations, and relationships from database schemas or natural language requirements across Prisma, TypeORM, SQLAlchemy, Django ORM, Drizzle, and more.

Detect SQL injection vulnerabilities by scanning source code and database queries for unsafe patterns like concatenation and unparameterized ORMs. Traces user input through Django, Rails, Express, and Go frameworks to flag vulnerabilities and suggest parameterized queries.

Designs and implements horizontal database sharding strategies for PostgreSQL, MySQL, and MongoDB, including shard key selection, data distribution analysis, query routing, and rebalancing for massive scale applications.

Detect, analyze, and prevent database deadlocks across PostgreSQL, MySQL, and MongoDB with lock queries, log parsing, code tracing, and monitoring scripts.

Monitor database transactions across PostgreSQL, MySQL, and MongoDB for long-running queries, lock contention, idle sessions, and anomalies. Automates real-time monitoring with diagnostic queries and alert configurations.

Manage database migrations across PostgreSQL, MySQL, MongoDB, and SQLite with version control, rollback capabilities, and automated schema evolution tracking. Supports migration tools like Prisma, Flyway, Alembic, and Knex for up/down patterns.

Manage PostgreSQL and MySQL database backup and recovery workflows with point-in-time recovery via WAL archiving, physical and logical backups, RPO/RTO planning, disaster recovery with automated failover, and backup verification.

Generate, validate, and deploy stored procedures, functions, and triggers for PostgreSQL, MySQL, and SQL Server databases, automating the creation of production-ready database code with error handling and transactions.

Configure and manage database replication topologies with automatic failover, read scaling, and lag monitoring for PostgreSQL, MySQL, and MongoDB.

Audit database connections, calculate optimal pool sizes, and configure or deploy PgBouncer/ProxySQL for PostgreSQL and MySQL to prevent connection exhaustion and improve throughput.

Run database tests with fixture loading, automatic transaction rollback, schema validation, and realistic test data generation across PostgreSQL, MySQL, MongoDB, SQLite, and Redis, including ORM support for Prisma, TypeORM, SQLAlchemy, Knex, and Drizzle.

Reduce database load by implementing multi-tier caching with Redis, in-memory caches, and CDN layers using cache-aside patterns, TTLs, and invalidation strategies.

Monitor PostgreSQL, MySQL, and MongoDB database health with real-time metrics, predictive alerting, and automated remediation. Detect performance degradation, resource exhaustion, and replication issues before they impact production.

Generate database audit logging implementations for PostgreSQL and MySQL using triggers, application-level logging, or CDC to track changes with before/after values, user identity, and timestamps for compliance monitoring and debugging.

Manage AWS data lakes and analytics pipelines: create Iceberg tables on S3 Tables, catalog Glue assets, ingest from JDBC, Redshift, Snowflake, BigQuery, and DynamoDB, run federated Athena queries, and operate OpenSearch domains for search, log, and trace analytics.

Coordinate long-running, multi-session development campaigns with persistent state, intent routing, and parallel agent fleets across worktrees and repositories. Includes automated intake-to-delivery pipelines, campaign cost tracking, structured code review, refactoring, test generation, and project documentation that persists across sessions.

Manage Azure infrastructure and AI services from .NET — provision databases, caches, messaging, and AI agents; authenticate with Entra ID; handle keys, events, and search.

Explore and manage local SQL databases token-efficiently—connect to PostgreSQL, MySQL, SQLite, or SQL Server, browse schemas with progressive disclosure, and fix connection issues—all from within Claude Code.

Deploy, manage, and troubleshoot cloud infrastructure, databases, and DevOps pipelines using specialized AI agents for architecture design, Terraform automation, database administration, performance optimization, CI/CD, incident response, and network debugging.

Analyze SQL query performance by generating execution plans, identifying bottlenecks, and receiving index suggestions with before/after comparisons.

Design database schemas, create zero-downtime migrations with rollback, and optimize PostgreSQL/MySQL query performance through automated analysis and bottleneck identification.

Generate SQL migration files (up/down) from schema change descriptions, with automatic detection of ORM and proper SQL dialect, column types, constraints, and indexes. Roll back migrations with data loss warnings, confirmation prompts, and post-rollback schema verification.

Design normalized database schemas via an interactive interview that outputs SQL DDL and text ERDs, and automatically generate Mermaid ERDs from existing ORM models, migration files, or live databases.

Automate diverse development workflows using pre-built AI agent skills for Google Workspace, databases, project management, and AI research, enabling tasks like email management, SQL queries, Jira operations, and autonomous research without manual scripting.

Optimize database performance for enterprise-scale B2B and multi-tenant SaaS platforms by tuning queries, indexing, connection pooling, scaling, and monitoring across PostgreSQL, MySQL, MongoDB, and Redis.

Run ClickHouse SQL directly in Python on local files (Parquet, CSV, JSON), cloud storage (S3), and remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without a server. Supports multi-step sessions, parametrized queries, UDFs, cross-source joins, and output to DataFrames.

Generate, validate, and deploy AWS CloudFormation templates across compute, storage, networking, database, security, and monitoring services, with CI/CD pipelines, cost optimization, and Well-Architected Framework reviews.

Optimize database performance for enterprise-scale B2B and multi-tenant SaaS platforms with query tuning, indexing strategies, connection pooling, scaling, and monitoring across PostgreSQL, MySQL, MongoDB, and Redis.

Diagnose and resolve database performance issues in multi-tenant SaaS environments, with automated query tuning, indexing recommendations, connection pooling configuration, and scaling strategies for PostgreSQL, MySQL, MongoDB, and Redis.

Configure Cloudflare Hyperdrive to connect Workers to PostgreSQL/MySQL databases with connection pooling, query caching, and TLS handling, resolving pool exhaustion and connection errors for Drizzle or Prisma ORMs.

Orchestrate a full AI engineering team of 12 specialized agents in Claude Code to handle complete software dev lifecycles: delegate planning, fullstack feature builds, UI design, refactoring, migrations, code reviews, security verification, debugging, DB analysis, onboarding, tooling, and research, backed by 15 automation hooks for pre-commit checks, branch protection, secret scanning, and quality enforcement via P7/P9/P10 methodologies.

Designs and reviews PostgreSQL/MySQL database schemas with normalization (1NF-3NF), relationships, constraints, and audit columns. Handles new database design, schema reviews, migrations, and fixes for missing PKs/FKs, wrong data types, denormalization, and EAV anti-patterns.

Deploy local or GitHub projects to Sealos Cloud with full lifecycle management: containerize apps, generate Kubernetes templates, provision databases and S3 storage, build Sealos Desktop apps, and visualize deployed resources.

Shard PostgreSQL and MySQL databases using hash, range, or directory strategies with built-in routers and shard key selection for horizontal scaling, multi-tenant isolation, and handling billions of records.

Automate dbt model development, debugging, refactoring, documentation, and data quality testing, plus Snowflake query optimization and cost analysis, via Claude Code skills that delegate to a specialized data engineering CLI agent.

Accelerate Laravel development with AI-assisted workflows for test-driven development (Pest/PHPUnit), safe migrations, queue operations, API evolution, code quality checks (Pint/static analysis), and pragmatic architecture patterns—compatible with Sail and non-Sail environments.

Design schemas, optimize queries, and ensure database reliability with expert agents for schema design, performance tuning, replication, and backup recovery

Analyzes slow SQL queries by reading execution plans, then recommends indexes and rewrites SQL to boost performance. Supports PostgreSQL, MySQL, SQLite, Prisma, and Drizzle.

Enforce an evidence-gated AI coding workflow: scan project context, analyze blast radius, plan with graph-informed task decomposition, execute with TDD checkpoints, auto-fix, verify with tests, and review before merge. Includes persistent memory, token compression, and Windows Git Bash hook resolution.

Manage the full Zeabur deployment lifecycle: authenticate, deploy projects and databases, configure domains and DNS, scale Kubernetes clusters, rent VPS servers, SSH into servers, view logs and metrics, run commands in containers, and create/publish templates.

Optimize PostgreSQL and MySQL queries using EXPLAIN ANALYZE, indexing strategies, and pg_stat_statements. Diagnose slow queries, N+1 problems, missing indexes, sequential scans, OFFSET pagination, temp table spills, and inefficient JOINs.

Review Python/FastAPI backend code with automated checks for SQLAlchemy ORM patterns, PostgreSQL query optimization, pytest test quality, and type safety, using a multi-step verification protocol to eliminate false positives

Manage a Kubernetes-native data center platform: create isolated projects with VPCs, deploy VMs and containerized apps, provision PostgreSQL/MariaDB databases, configure networking and storage, manage RBAC groups and secrets with KMS-backed encryption, and request auto-renewing TLS certificates — all through kubectl.

Manage Reverse ETL pipelines with drt: generate YAML sync configs, initialize projects, debug failures, and migrate from Census, Hightouch, or custom scripts.

Create and manage Reverse ETL pipelines using drt — generate sync configurations, initialize projects, debug failures, migrate from Census and Hightouch, and run diagnostic checks on data warehouse connections.

Read and write data from 25+ Oracle, cloud, and SaaS sources (Oracle DB, OCI, Azure, Snowflake, Salesforce, etc.) directly in Oracle AIDP notebooks using Spark connectors. Enables data ingestion, external catalogs, and SQL pushdown across hybrid and multi-cloud environments.

Generate optimized database schemas and migration scripts for PostgreSQL, MySQL, and MongoDB, with support for ORM integration via Prisma, TypeORM, Sequelize, and Mongoose.

Manage the full computer vision dataset lifecycle in FiftyOne: import, curate, deduplicate, visualize, run model inference, evaluate predictions, and export to standard formats. Also build custom plugins and UIs for the FiftyOne platform.

Build, validate, and migrate data pipelines with ETL reliability patterns, data profiling, quality checks, schema inference, and synthetic test data generation for CSV, Parquet, JSON, and SQL databases.

Develop and test microservices locally against real Kubernetes environments using traffic mirroring, database branching, queue splitting, and chaos injection. Configure mirrord for local debugging, generate preview environments, and integrate with CI pipelines.

Generate Symfony 7/8 code following modern conventions: Doctrine ORM 3 entities and migrations, API Platform 4 resources with DTOs, REST controllers, JWT auth, Messenger async processing, DDD patterns, and layered architecture with tests.

Scaffold production-ready Go web applications with Echo, Templ, HTMX, Tailwind CSS, sqlc, and goose, or convert an existing project to this stack. Includes guidance on htmx patterns and templUI component library usage.

Optimize SQL queries by analyzing execution plans, recommending indexes, and rewriting inefficient queries for PostgreSQL, MySQL, and other relational databases to improve database performance and efficiency.

Format SQL queries with beautification, syntax highlighting, and optimization hints across multiple dialects including PostgreSQL, MySQL, SQL Server, Oracle, and SQLite.

Generate Dockerfiles, Docker Compose configs, and SSL/TLS setups with Traefik or Nginx, and diagnose container issues for multi-service applications.

Structured software development workflow: plan, document, review, and track work with ADRs, implementation plans, work items, and PR reviews. Integrates with Linear and Jira for issue tracking, runs Playwright-based UI analysis, and enforces code quality through multi-lens reviews.

Generate production-ready docker-compose.yml files with pre-configured service templates for PostgreSQL, Redis, MongoDB, and MySQL, including networking, volumes, health checks, and environment variable management.

Orchestrate a full product lifecycle from research through release readiness with human-in-the-loop gates, artifact traceability, and automated spec-to-code verification across express, lite, standard, and V-model modes.

Optimize database performance for enterprise-scale B2B applications, including multi-tenant query tuning, indexing strategies, connection pooling, and cloud database scaling for PostgreSQL, MySQL, and MongoDB.

Manage and troubleshoot Laravel Docker development environments with 50+ CLI commands for service management, health checks, database operations, Xdebug, SSL, DNS, and multi-project isolation.

Manage Cloud SQL for MySQL instances: provision databases, users, and clones; explore schemas, analyze query execution plans, and monitor active queries; create and restore backups; troubleshoot slow queries using PromQL metrics and structure analysis.

Diagnose WordPress site health with automated audits covering security, performance, code quality, and database, then build or modify sites interactively with version-controlled steps, producing Local WP importable zips and structured reports.

Migrate Azure cloud services to local Docker containers with emulators (Azurite, Cosmos DB, SQL Server, Service Bus) and Docker Compose. Automates infrastructure extraction, database export, and hot-reload watch mode for production-parity local development.

Analyze product data with natural-language SQL generation, cohort retention analysis, and A/B test significance testing. Upload CSV/Excel files to compute retention curves, feature adoption trends, and statistical significance with launch/extend/stop recommendations.

Build and debug Nette Framework applications with Latte templates, NEON configuration, DI containers, database Explorer API, forms, and schema validation. Includes Tracy debugger interpretation, Tester unit tests, and automated PHPCS coding standards.

Orchestrates a complete feature-development workflow: plan specs, DB schemas, and architecture in .spec/ files, generate code via agent teams, run parallel code reviews and security scans, verify acceptance criteria in a live browser, and batch-sync everything to Notion on task closure.

Accelerate product data analysis by generating SQL queries from natural language, running cohort analysis on user engagement data, and evaluating A/B test results with statistical significance and sample size checks.

Develop WooCommerce plugins with expert support for PHP 8.x, hooks, REST API, checkout blocks, payment gateways, shipping, HPOS, admin UI, testing, and deployment.

Manage OceanBase cluster lifecycle, tenant operations, and SeekDB HA with benchmarking via obd CLI

Accelerates solo product development from concept to implementation: generate database schemas, technical architectures, PRDs, UI/UX designs, and academic writing, all organized into project outputs.

Delegate infrastructure provisioning, CI/CD pipeline creation, and database optimization to specialized agents covering Terraform, CloudFormation, Ansible, Kubernetes, AWS, GCP, Azure, PostgreSQL, MySQL, and more.

Generate complete database schemas with tables, fields, indexes, and ER diagrams from business domain descriptions. Outputs SQL scripts, Markdown documentation, DrawDB JSON, and DBML files for MySQL, PostgreSQL, and SQL Server.

Provides a comprehensive set of AI-driven skills for Ruby on Rails development, covering the full lifecycle from project setup and TDD to code review, security auditing, database migrations, engine creation, and release management.

Compare PostgreSQL and MySQL database schemas across environments, detect all differences in tables, columns, indexes, constraints, and triggers, then generate safe migration scripts with transaction safety and rollback procedures.

Generate production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, and SQL Server, with input validation, error handling, and transaction safety.

Manage database migrations across multiple database systems with version-controlled up/down patterns, supporting schema evolution tracking and rollback operations.