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 and optimize SQL across data warehouses, profile datasets, and generate interactive dashboards or publication-quality charts from queries or files. Automates data analysis with natural language queries and connects to analytics platforms like Amplitude and Hex.

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.

Develop production-grade Go applications with AI-assisted skills covering project layout, concurrency, profiling, observability, testing, CI/CD, and idiomatic coding patterns across the full development lifecycle.

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.

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.

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.

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

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.

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.

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.

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.

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 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.

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.

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.

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 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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

Manage AWS data lake and analytics workflows: create and manage S3 Tables (Iceberg), import data from databases and S3, query with Athena, manage Glue connections and catalogs, and store/query vector embeddings with S3 Vectors.

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.

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.

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 agent-guided scaffolding, content modeling, PHP/Twig coding standards, DDEV local environment, and deployment to Craft Cloud or Servd, plus code review and debugging agents

Deploy any local or GitHub project to Sealos Cloud with a single command, including automatic cloud-native readiness assessment, Dockerfile generation, and container orchestration template creation. Manage cloud databases (PostgreSQL, MySQL, MongoDB, Redis), S3 object storage, and build Sealos Desktop apps — all from within Claude.

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.

Manage a Kubernetes-native data center platform: provision projects with isolated VPCs, deploy VMs via KubeVirt, create PostgreSQL or MariaDB databases, expose services with HTTPS/TLS or EIP/LoadBalancer, configure RBAC and multi-tenancy, handle encryption keys and managed secrets via OpenBao, request x509 certificates, and manage Kubernetes cluster day-2 operations — all through kubectl and custom resource definitions.

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.

Orchestrate Claude Code sessions as a Kanban board with agent lifecycle hooks, role-based task assignment, and automated verification of web pages, CLI tools, APIs, databases, and libraries, plus fuzzy exploration and plan decomposition into worker-ready tickets.

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.

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.

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 Nette Framework applications with Latte templating and NEON config, covering frontend (Vite, Tailwind, JS/TS) and backend (presenters, DI, database, forms), plus testing (Tester), debugging (Tracy), and data validation (Schema).

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.

SDD implements a complete spec-driven development pipeline for Claude Code: survey a codebase or bootstrap greenfield, walk gated stages from idea capture → spec → architecture → data model → OpenAPI contract → task breakdown → TDD implementation → review → ship, while maintaining a living roadmap (Now/Next/Later). Every stage hard-refuses to proceed if the previous artifact is missing, and the depth of Q&A and ideation is tunable.

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.

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.

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.

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.

Automate full feature workflow: create Notion-synced .spec/ tasks, generate specs/DB/arch diagrams, build/review Java backend code with Agent Teams, verify acceptance in Chrome browser, batch sync completions to Notion with Git commits.

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.

Build full-stack Frappe/ERPNext applications by scaffolding apps and DocTypes, generating Python backend controllers/APIs/server scripts, JavaScript client scripts, React SPAs or React Native mobile frontends, executing bench CLI commands, debugging issues, running tests, planning features, customizing ERPNext, and managing GitHub workflows with specialized agents.

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.

Build and customize WooCommerce plugins end-to-end: create extensions with PHP 8.x patterns, custom payment gateways, shipping methods, Gutenberg blocks, admin UIs, REST API endpoints, and HPOS-compliant data stores. Includes testing (PHPUnit, Playwright), dev environment setup, deployment automation, security hardening, and performance optimization.

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.

Develop and customize Magento 2 Open Source stores: build modules, admin UIs, REST/GraphQL APIs, catalog extensions, checkout customizations, and EAV attributes; write PHP 8.x code, unit tests, and deploy with CI/CD pipelines

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.