MySQL plugins

Delegates product strategy, legal/licensing, business analysis, project management, UX research, content marketing, customer success, technical sales, technical writing, and WordPress development to specialized AI agents

Write SQL across data warehouses, profile datasets, and generate interactive dashboards and publication-quality charts. Connect to BigQuery, Amplitude, Hex, and Atlassian for integrated data analysis and reporting.

Generate SQL queries from natural language descriptions using your database schema for PostgreSQL, MySQL, or BigQuery. Analyze CSV or Excel user data to produce cohort retention heatmaps, engagement trends, churn insights, and research recommendations. Evaluate A/B tests for statistical significance, confidence intervals, lift, and ship/extend/stop decisions with Python-powered reports.

Analyze slow SQL queries and receive optimized rewrites, index recommendations, execution plan insights, anti-pattern fixes, and performance estimates for PostgreSQL, MySQL, and SQLite databases.

Design normalized relational database schemas for PostgreSQL and MySQL from natural language requirements. Generate DDL statements, constraints, indexes, relationships, migrations, checklists, and Mermaid ERDs following best practices and normalization guidance.

Audit PostgreSQL, MySQL, and MongoDB databases for security risks including misconfigurations, privileges, encryption, network exposure, default credentials, and SQL injection in app code. Run scans for 50+ OWASP vulnerabilities, generate compliance reports, automated remediation scripts, and audit trails from your IDE.

Interpret EXPLAIN plans and query metrics from PostgreSQL, MySQL, and MongoDB to detect bottlenecks like sequential scans, missing indexes, and inefficient joins. Receive targeted SQL optimization recommendations with expected performance impacts.

Automate archiving historical PostgreSQL/MySQL records to archive tables or cloud storage (S3, Azure Blob, GCS) using age/status-based rules, retention policies, compression, and compliance tracking to shrink primary database size and manage cold data.

Analyze PostgreSQL, MySQL, and MongoDB query workloads to detect missing indexes causing sequential scans, identify unused indexes, recommend optimal configurations, estimate performance impacts, and generate SQL scripts for index creation and drops.

Compare PostgreSQL and MySQL schemas across database environments to generate idempotent migration scripts with transaction safety, validation checks, rollback procedures, and detailed diff reports.

Design and implement partitioning strategies for PostgreSQL and MySQL tables using range, list, hash, and composite methods to handle massive datasets. Automate schema design, maintenance routines, query optimization, and data retention policies for improved performance.

Introspect PostgreSQL, MySQL, SQLite, and MongoDB schemas to generate Markdown documentation and interactive HTML reports with ERD diagrams, relationships, indexes, constraints, views, procedures, and data dictionaries for onboarding, audits, and compliance.

Generate, validate with error handling and transactions, and deploy production-ready stored procedures, functions, triggers, and custom logic directly to PostgreSQL, MySQL, or SQL Server databases using natural language triggers or commands.

Scan codebases for SQL injection vulnerabilities by tracing user inputs through code to database queries, identifying unsafe patterns like string concatenation and unparameterized ORM usage in Django, Rails, Express, and Go apps. Get risk reports and mitigation recommendations via skills or direct commands.

Build .NET applications that provision Azure infrastructure (databases, caches, bots), integrate AI services (agents, OpenAI, voice, document intelligence, search), manage events/messaging (Event Grid, Hubs, Service Bus), authenticate via Entra ID, and handle Key Vault cryptography using official SDKs and ARM clients.

Provision and manage isolated test environments using Docker Compose and Testcontainers for databases, caches, queues like PostgreSQL, MySQL, Redis, DynamoDB. Generate docker-compose files, env vars, seed data scripts, startup scripts, and cleanup code to enable reliable, reproducible testing without local setup conflicts.

Implement disaster recovery and point-in-time recovery (PITR) workflows for PostgreSQL and MySQL databases using WAL archiving, automated backups to S3 or local storage, failover procedures, RPO/RTO planning, testing runbooks, and multi-cloud support for AWS, GCP, Azure.

Automate database testing workflows by generating test suites with data factories, transaction wrappers for automatic rollback, schema validation, assertions, cleanup, fixtures, migrations, integrity checks, and performance monitoring across PostgreSQL, MySQL, MongoDB, SQLite, Redis using Prisma, Drizzle, Jest, Pytest.

Set up real-time monitoring for database transactions in PostgreSQL, MySQL, and MongoDB to detect long-running queries, lock contention, idle sessions, throughput issues, and rollbacks. Generate Python scripts, SQL queries, and alert configs for automated performance alerting via CLI.

Implement multi-tier database caching using Redis for L2 distributed cache, in-memory L1 cache, and CDN layers with cache-aside and write-through patterns, TTLs, and invalidation strategies to reduce database load and boost read performance for PostgreSQL and MySQL setups.

Audit database connections, calculate optimal pool sizes, configure app-level pooling parameters, and deploy PgBouncer or ProxySQL for PostgreSQL and MySQL to prevent exhaustion and boost throughput. Implement best practices with code examples for Node.js, Python, and Java.

Monitor PostgreSQL, MySQL, and MongoDB health via CLI queries for connections, throughput, disk usage, cache ratios, and locks. Configure alerting thresholds, receive predictive alerts with remediation guidance, and deploy Grafana dashboards using Prometheus exporters for real-time oversight.

Implement trigger-based audit logging for PostgreSQL and MySQL databases to track INSERT, UPDATE, and DELETE operations with metadata for compliance, security monitoring, and debugging. Generate SQL trigger templates, CDC strategies, and application-level logging setups.

Detect and resolve database deadlocks in PostgreSQL, MySQL, and MongoDB by running lock queries, parsing logs, tracing code, and applying preventive patterns. Generate Python and Node.js monitoring scripts, SQL analyzers, prevention docs, and dashboards for ongoing deadlock management.

Introspect PostgreSQL or MySQL schemas to generate ORM models, migrations, and relations for Prisma, Drizzle, TypeORM, Sequelize, SQLAlchemy, and Django ORM. Reverse-generate database schemas from models supporting JavaScript/TypeScript, Python, C#, Java, Ruby, PHP, and more.

Configure replication topologies, automate failover, monitor lag, resolve conflicts, and scale read replicas for high-availability setups in PostgreSQL, MySQL, and MongoDB databases.

Manage complete database migration workflows: generate timestamped up/down SQL or ORM files, validate schemas, execute migrations, perform rollbacks, and track evolution with version control for PostgreSQL, MySQL, MongoDB, and SQLite using Flyway, Alembic, Prisma, or Knex.

Implement backup strategies for databases (PostgreSQL, MySQL, MongoDB), filesystems, and AWS resources using tar, rsync, pg_dump, and S3. Automate scheduling, retention, encryption, verification, and disaster recovery, while generating configs, setup code, and documentation for production DevOps.

Audit PostgreSQL and MySQL databases for integrity issues including NULLs, orphans, invalid formats, ranges, and duplicates, then generate and enforce CHECK constraints, foreign keys, and triggers. Extend validation to application level with type checks, regex patterns, foreign key integrity, and custom business rules.

Generate automated backup scripts, cron schedules, restore procedures, monitoring setups, and recovery plans for PostgreSQL, MySQL, MongoDB, and SQLite databases, including compression, encryption, and retention policies with AWS support.

Implement horizontal database sharding for PostgreSQL, MySQL, and MongoDB at massive scale. Select shard keys, analyze data distribution, route queries, rebalance shards, and generate router code, migration plans, and monitoring setups using consistent hashing and virtual nodes.

Delegate specialized AI agents to design cost-optimized cloud architectures on AWS/Azure/GCP using Terraform, administer and optimize PostgreSQL/MySQL/MongoDB databases, troubleshoot DevOps outages with logs/metrics analysis, configure CI/CD pipelines with Docker/Kubernetes, and debug networks with nginx/HAProxy.

Connect to WordPress sites via WP-CLI over SSH or REST API, then create and manage posts, pages, media, categories, tags, menus; edit Elementor pages for text, images, styles, layouts, sections, and templates using interactive commands and skills.

Apply 28 prioritized best-practice rules for ClickHouse schema design, query optimization, and data ingestion, with companion skills for running ClickHouse SQL in Python, reviewing schemas and queries, writing Node.js client code, troubleshooting performance issues, and setting up local or cloud ClickHouse environments.

Optimize SQL queries and analyze execution plans in plain English for PostgreSQL, MySQL, SQLite, and SQL Server. Identify costs and bottlenecks, get index suggestions and rewrites, then compare before/after performance using EXPLAIN ANALYZE.

Manage AWS data lakes and analytics workflows: create and query Iceberg tables on S3 Tables, run Athena SQL across Glue and Redshift catalogs, ingest data from JDBC databases, Redshift, Snowflake, BigQuery, and DynamoDB, audit Glue Data Catalog assets, and store/query vector embeddings on S3 Vectors for semantic search and RAG.

Perform Five Whys root cause analysis to identify issues and solutions, generate Mermaid ERDs from SQL migrations or database schemas, and follow structured 4-step guides for problem-solving and project building through to deployment.

Design optimized PostgreSQL schemas from business requirements with entity modeling and SQL DDL, generate Node.js migration frameworks with zero-downtime strategies and rollbacks, and optimize performance for PostgreSQL/MySQL by analyzing slow queries, indexes, execution plans, and resource usage.

Generate realistic test data from schemas or models, respecting constraints, relationships, and locales, then output as JSON, CSV, SQL INSERTs, or fixtures with validation reports. Seed development databases idempotently via transactional scripts that include cleanup and verify inserted counts for Prisma, Django, and SQL databases.

Optimize PostgreSQL and MySQL query performance by running EXPLAIN ANALYZE to identify issues, locks, and patterns, generating structured reports with improvement estimates and suggestions, then applying index recommendations via safe concurrent migrations with redundancy checks.

Interactively design database schemas from application requirements, defining entities, relationships, indexes, and constraints while generating SQL DDL and text-based ERDs. Create visual Mermaid ERDs (saved to docs/erd.md) from existing schemas, ORM models, migrations, or live databases, with optional DBML output and counts of tables/relationships.

Manage the full Airflow data engineering lifecycle: author, test, debug, and deploy DAGs; profile and trace lineage across warehouses; migrate between Airflow versions; and troubleshoot production deployments via CLI.

Develop and manage Tencent CloudBase applications: deploy cloud functions and CloudRun services, query and manage NoSQL/MySQL databases, call AI models (DeepSeek, Hunyuan, etc.), handle authentication and storage, and integrate WeChat Mini Programs — all via MCP.

Accelerate Java Spring Boot development by generating CRUD apps, REST APIs, and AI integrations with LangChain4j; write unit/integration tests; integrate AWS services like RDS, DynamoDB, S3, Lambda; refactor code, audit security/dependencies, and produce documentation/architecture reviews via agents, commands, skills, and LSP support.

Build product metrics frameworks with North Star metrics, KPI trees, and counter-metrics; explain, optimize, and generate SQL queries for PostgreSQL, MySQL, SQLite; create structured dashboard specs including KPIs, charts, and layouts from business questions for BI tools like Looker or Grafana.

Optimize PostgreSQL, MySQL, MongoDB, and Redis performance for enterprise B2B SaaS and multi-tenant platforms by tuning queries, designing indexing strategies, configuring connection pooling, implementing scaling solutions, and setting up monitoring workflows.

Generate production-ready AWS CloudFormation templates for VPCs, EC2, ECS, RDS, DynamoDB, Lambda, S3, CloudFront, ElastiCache, Bedrock, and security groups; deploy ECS services via GitHub Actions CI/CD; bootstrap SAM projects; create Draw.io architecture diagrams; automate AWS CLI workflows; optimize costs; and review designs with expert agents.

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.

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

Optimize PostgreSQL, MySQL, MongoDB, and Redis performance for enterprise B2B SaaS and multi-tenant platforms by tuning queries, implementing indexing strategies, configuring connection pooling, and planning scaling with monitoring.

Design normalized PostgreSQL and MySQL database schemas up to 3NF with relationships, constraints, and audit columns. Review existing schemas to identify and fix missing primary/foreign keys, incorrect data types, premature denormalization, or EAV anti-patterns. Use for new databases, schema migrations, or improvements.

Implement horizontal sharding for PostgreSQL and MySQL databases using hash, range, or directory strategies. Select shard keys, configure routers, manage hotspots and rebalancing, and handle cross-shard queries to scale to billions of records with multi-tenant isolation.

Develop and deploy Craft CMS 5 sites and plugins with AI agents that scaffold projects, write php/twig code following conventions, debug bugs, review PRs, and manage hosting on Craft Cloud or Servd

Deploy GitHub projects to Sealos Cloud with automated containerization, cloud-native readiness assessment, and management of cloud databases and object storage.

Delegate database engineering to AI agents that design schemas with normalization, indexing, and migrations; optimize SQL queries through execution plans, rewrites, and parameter tuning; and engineer reliability via replication, backups, high availability, monitoring, and failover for PostgreSQL, MySQL, SQLite, MongoDB, Redis, Prisma, and Drizzle.

Automatically reverse-engineer legacy codebases into living architecture docs with Mermaid diagrams, then orchestrate a multi-agent risk audit that delegates parallel specialists (scalability, concurrency, chaos/SRE, security) and consolidates findings into a prioritized executive trust report.

Optimize slow PostgreSQL and MySQL queries: analyze EXPLAIN ANALYZE plans, identify missing indexes, fix N+1 problems, sequential scans, OFFSET pagination issues, temp table spills, and inefficient JOINs using pg_stat_statements and best practices.

Enforce Python code quality with a verified-issue workflow: review FastAPI routing, SQLAlchemy database patterns, PostgreSQL queries, pytest tests, and general Python type safety, using parallel linters (ruff, mypy) and multi-step verification to eliminate false positives.

Delegate high-performance game development to AI experts: implement Unity ECS/DOTS/Burst patterns in C#, Godot 4 GDScript architecture/signals/state machines, and Minecraft Bukkit/Spigot plugins with Java APIs, player/world management, databases, performance tweaks, and Docker.

Provision and manage a complete Kubernetes-native data center: KubeVirt VMs, managed PostgreSQL/MariaDB databases, Helm-deployed apps, clusters, networking, storage, RBAC, secrets, KMS, and certificates—all via kubectl and CLI.

Automate data classification for privacy compliance: discover PII in structured/unstructured data, build GDPR RoPA inventories, track lineage, label special categories, detect bias in AI datasets, and harmonize policies across GDPR/CCPA/HIPAA using AWS Macie, Azure Purview, and regex/spaCy.

Configure Cloudflare Hyperdrive in Workers projects for pooled, cached connections to PostgreSQL or MySQL databases, resolving pool exhaustion, TLS errors, and connection refusals when using Drizzle or Prisma.

Build, extend, debug, validate, productionize, and explore REST API data pipelines using dlt: scaffold from APIs or sources, add endpoints, inspect runs/errors, check schemas/data quality, query loaded datasets, manage workspaces via MCP.

Initialize drt Reverse ETL projects with BigQuery or PostgreSQL, generate YAML sync configs from dbt models or SQL to destinations like Slack, HubSpot, GitHub Actions, or databases, debug auth timeouts and config errors, and migrate pipelines from Census or Hightouch.

Build high-quality computer vision datasets and models with FiftyOne: import/export datasets, run inference, evaluate predictions, find duplicates, visualize embeddings, and develop custom plugins — all from within Claude.

Orchestrate Claude Code sessions as a kanban board with role-based agents, lifecycle management, and end-to-end testing of web, CLI, HTTP, database, and library APIs via browser automation, snapshot diffing, and log verification.

Optimize SQL queries for PostgreSQL and MySQL by analyzing execution plans, recommending indexing strategies, rewriting JOINs and subqueries or CTEs, and applying performance tuning to boost database efficiency.

Format selected SQL queries or entire files in your editor with beautification, syntax highlighting, and optimization hints. Supports PostgreSQL, MySQL, and SQLite dialects to improve code readability and catch potential issues.

Generate optimized database schemas and automated migration scripts for PostgreSQL, MySQL, and MongoDB, with ORM integration for Prisma, TypeORM, Sequelize, and Mongoose to automate data persistence setup from manual specs.

SDD for Claude Code walks a feature through the full lifecycle — from idea capture through spec, architecture, data model, API design, task breakdown, TDD implementation, review, and shipping — using gated atomic skills and specialized subagents. It maintains an outcome-oriented roadmap, a living glossary, ADRs, and test plans, and surfaces a dashboard UI for pipeline visibility.

Dockerize Node/Python/PHP/Go apps by generating optimized multi-stage Dockerfiles, docker-compose.yaml, .dockerignore, and .env files; provision secure, persistent PostgreSQL/MySQL/MongoDB/Redis containers with health checks; configure SSL/TLS proxies via Traefik or Nginx; diagnose and fix container failures, networking, permissions, and port issues using logs and docs.

Generate complete docker-compose.yml files with pre-configured services for PostgreSQL, Redis, MongoDB, MySQL, and Elasticsearch, including environment variables, networking, volumes, and health checks to spin up local multi-service environments instantly.

Develop full-stack Nette applications with conventions for Latte templates, NEON config, DI, database, forms, architecture, and testing, plus Vite frontend integration and Tracy debugging.

Adds Laravel-specific skills for test-driven development with Pest/PHPUnit, safe migrations, queue management, quality checks (Pint, Insights), and architecture patterns (DTOs, Form Requests, Actions). Works with Sail and non-Sail environments, includes Blade component patterns, API resources, and Playwright E2E testing.

Optimize multi-tenant database performance for enterprise B2B and SaaS applications by tuning queries, refining indexing strategies, implementing connection pooling, and scaling PostgreSQL, MySQL, MongoDB, and cloud databases with AI-driven data architecture advice.

Orchestrates structured, multi-phase software development workflows with interactive planning, design analysis, code review, issue tracking (Jira/Linear), commit management, and pull request automation.

Connect Oracle AIDP Spark notebooks to 23+ enterprise data sources (Oracle DB, AWS S3, Azure ADLS, Salesforce, Snowflake, PostgreSQL, MySQL, etc.) for read/write data pipelines using JDBC, REST, and cloud-native connectors.

Converts raw SQL into type-safe Kysely TypeScript code and provides backend development skills including code review, security auditing, documentation generation, and release automation

Manage and troubleshoot Laravel Docker development environments with docker-local CLI expertise. Spin up/down services (PHP, MySQL, PostgreSQL, Redis, MinIO, Traefik), run health checks and status commands, diagnose access issues like SSL/DNS/404s via nginx logs, set up multi-project isolation, Xdebug, queues, and databases without app code changes.

Connect to WordPress sites via SSH, Docker, git, or local dirs to run structured diagnostics yielding A-F graded reports on security, performance, code quality, database bloat, and architecture. Build full FSE sites from natural language descriptions, screenshots, or URL scrapes as Local WP importable zips. Interactively modify sites with git-committed steps and export versions.

Load post-training knowledge patches for Drizzle ORM 1.0 beta (up to 0-beta.19), enabling workflows with consolidated validator imports (Zod, Valibot), Effect Schema support, node-sqlite driver, and .comment() query tagging in TypeScript projects using PostgreSQL, MySQL, or SQLite.

Patch Claude's knowledge with SQLx updates from 0.8.3 to 0.9.0-alpha.1, enabling accurate assistance on new features, configs, transactions, and breaking changes for Rust database workflows with PostgreSQL, MySQL, and SQLite.

Extract Azure resource groups via CLI, generate Docker Compose stacks with 2025 emulators (Azurite, SQL Server 2025, Cosmos DB vnext, Service Bus), export databases from Azure SQL/PostgreSQL/MySQL to local containers, convert App Services to Dockerfiles, apply production security patterns, and enable hot reload via Watch mode for mirrored local development.

Architect scalable databases by selecting SQL/NoSQL/TimeSeries technologies, designing normalized schemas with PostgreSQL best practices, planning migrations, and optimizing complex SQL queries for OLTP/OLAP performance in cloud-native systems like PostgreSQL, MySQL, MongoDB, Redis, and DynamoDB.

Manage Cloud SQL for MySQL instances on GCP: provision databases and users, execute SQL queries, create backups and restores, clone environments, and troubleshoot performance using query execution plans and system metrics.

Generate CRUD application services, scaffold DDD entities end-to-end, review code against ABP v10.4 best practices, and audit solutions for migration to .NET 10 with multi-tenancy, modularity, and microservice support.

Generate optimized SQL queries from natural language using database schemas for PostgreSQL, MySQL, BigQuery and more; analyze user cohorts from CSV/Excel/JSON data to reveal retention curves, churn patterns, and adoption trends with visualizations and recommendations; evaluate A/B tests for statistical significance, sample size, confidence intervals, and launch decisions.

Generate optimized SQL queries from natural language for BigQuery, PostgreSQL, MySQL, and Snowflake; perform cohort analysis on CSV/Excel user data to compute retention rates, visualize trends, and detect anomalies; evaluate A/B tests with statistical significance, confidence intervals, and launch recommendations.

Streamline solo product development: transform ideas into PRDs, user personas, database schemas (MySQL/PostgreSQL with ER diagrams/SQL), UI/UX designs and frontend code (HTML/CSS/JS, React/Vue/Tailwind), technical architectures with deployment strategies, and academic prose—all output to organized docs.

Develop and customize WooCommerce extensions with PHP 8.x, including plugins, payment gateways, shipping methods, Gutenberg blocks, and REST API endpoints, while managing HPOS, admin UI, testing, and deployments, aided by an expert agent and PHP Intelephense LSP.

Develop, debug, and optimize full WordPress projects: build Gutenberg blocks and block themes with PHP/JS, create secure plugins and REST API endpoints, profile backend performance, run WP-CLI ops, test in disposable Playground instances, and analyze with PHPStan.

Design complete database schemas—including tables, fields, indexes, and ER diagrams—from business requirements or domain descriptions. Generate SQL scripts, Markdown docs, and DrawDB JSON/DBML files tailored for MySQL, PostgreSQL, and SQL Server.

Configure Infisical Dynamic Secrets to generate on-demand short-lived credentials for PostgreSQL, MySQL, Redis, MongoDB databases, AWS and GCP IAM roles, SSH certificates, and Kubernetes service accounts, including prerequisites, TTL settings, and lease management across 27 providers.

Provides a comprehensive expert agent and skills for Magento 2 Open Source development — building custom modules with DI, plugins, and EAV; creating REST/GraphQL APIs; customizing checkout, catalog, and admin UI; writing tests; optimizing performance and security; and deploying with CI/CD. Includes PHP code intelligence via Intelephense LSP and Docker validation hooks.

Coordinate multiple AI agents as a team to build, test, debug, and review code through structured workflows with human approval gates, agent handoffs, and automated context tracking across sessions.

Write reliable integration tests in .NET and Go by spinning up disposable Docker containers for databases (PostgreSQL, MySQL, Redis, MongoDB), message queues (Kafka, RabbitMQ), and services using Testcontainers. Handle networking, wait strategies, cleanup, and CI/CD workflows.