MySQL Read Only Query Skill
Skill Verified ActiveExecute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.
To safely and efficiently query multiple MySQL databases for data analysis and exploration, with intelligent database auto-selection and robust safety features.
Features
- Execute read-only SQL queries
- Support for multiple MySQL database connections
- Intelligent database auto-selection based on descriptions
- Blocks all write operations (INSERT, UPDATE, DELETE, etc.)
- Configurable SSL support and query timeouts
Use Cases
- Querying MySQL databases for data analysis
- Exploring database schemas and tables
- Checking database contents for specific information
- Connecting to and managing multiple database instances
Non-Goals
- Performing any write operations (INSERT, UPDATE, DELETE, DROP, etc.)
- Executing multi-statement SQL queries
- Operating on databases other than MySQL
- Providing a full database administration interface
Workflow
- List configured databases using `--list`
- Match user intent to database descriptions for selection
- Explore database structure using `--tables` or `--schema`
- Execute SQL queries with optional `--limit`
Prerequisites
- Python 3.8+
- mysql-connector-python: `pip install -r requirements.txt`
Installation
First, add the marketplace
/plugin marketplace add sanjay3290/ai-skills/plugin install ai-skills@ai-skillsQuality Score
VerifiedTrust Signals
Similar Extensions
DBHub Database Query Guide
100Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files
Agentdb Query
99Query AgentDB through the controller bridge -- semantic routing, hierarchical recall, causal graphs, context synthesis, pattern store/search