mysqlWrite correct MySQL queries avoiding common pitfalls with character sets, indexes, and locking.
Install via ClawdBot CLI:
clawdbot install ivangdavila/mysqlRequires:
Grade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Generated Mar 22, 2026
Handles high-volume transactions with proper indexing and InnoDB transactions to ensure data consistency during order placement, payment processing, and inventory updates. Uses utf8mb4 for international product names and emoji in reviews, with connection pooling to manage peak shopping traffic.
Generates complex aggregated reports with strict GROUP BY compliance and transaction isolation to maintain audit trails. Implements deadlock retry logic for concurrent updates and uses EXPLAIN ANALYZE to optimize query performance for large datasets spanning multiple fiscal periods.
Supports multi-tenant data isolation with efficient indexing strategies and connection management for scalable user bases. Uses UPSERT patterns for user preference updates and monitors replication lag when distributing reads across primary and replica instances for high availability.
Manages text-heavy content with utf8mb4 collation for global language support and prefix indexes on TEXT columns. Implements row-level locking for concurrent editorial workflows and uses InnoDB exclusively for reliable crash recovery during content publishing operations.
Processes streaming sensor data with efficient INSERT patterns and buffer pool optimization for time-series storage. Uses statement-based replication cautiously with deterministic functions and monitors max_connections to handle high-frequency device communications without connection timeouts.
Offers tiered database management plans with features like query optimization, index tuning, and replication monitoring. Revenue scales with customer data volume and required uptime SLAs, leveraging MySQL's transaction support for billing and usage tracking.
Provides expert MySQL configuration, migration from MyISAM to InnoDB, and performance tuning for enterprise clients. Revenue comes from project-based fees for database design, production deployment, and ongoing optimization contracts.
Hosts and maintains MySQL instances with automated backups, replication setup, and 24/7 monitoring. Revenue is generated through hosting fees based on server resources, with premium support for handling deadlocks, connection pooling, and scalability issues.
💬 Integration Tip
Ensure consistent utf8mb4 collation across all application connections and tables to prevent JOIN performance issues, and configure InnoDB buffer pool size appropriately for your server's RAM to optimize query performance.
Scored Apr 18, 2026
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Design data models for construction projects. Create entity-relationship diagrams, define schemas, and generate database structures.
MarkItDown is a Python utility from Microsoft for converting various files (PDF, Word, Excel, PPTX, Images, Audio) to Markdown. Useful for extracting structu...
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.