MySQL Database Skill
Executes safe SELECT queries against MySQL and MariaDB databases with built-in connection pooling and SQL injection prevention.
The source repository doesn't declare a license. Check its terms before reusing the code.
Key features
- Read-only SELECT query validation and execution
- Efficient connection pooling and environment-based configuration
- SQL injection prevention using parameterized queries
- Actionable error handling for connection and authentication issues
- Automatic result formatting as Markdown tables or JSON
Use cases
- Querying local database records for debugging and data analysis
- Integrating live database data into documentation or project summaries
- Retrieving aggregate statistics and counts from MySQL or MariaDB
FAQ
How does this skill ensure database security?
The skill enforces a read-only policy by only allowing SELECT statements and uses parameterized queries to prevent SQL injection. It also focuses on local connections and secure environment variable management for credentials.
What does the MySQL Database Skill do?
This skill enables Claude Code to securely connect to and query MySQL or MariaDB databases. It specializes in executing SELECT queries, ensuring data can be retrieved and analyzed safely during the development process.
Does it support connection pooling?
Yes. The skill includes built-in connection pooling to manage database resources efficiently, ensuring fast query execution and stable performance even during frequent interactions.
In what format are the query results returned?
To make data easy to read, the skill automatically formats results into Markdown tables for quick visual inspection or JSON for structured data processing within your TypeScript or CLI workflows.
When should I use this skill?
Use this skill whenever you need to inspect database records, verify data migration results, or fetch specific information from your database while coding. It is triggered by keywords like 'mysql', 'mariadb', or 'sql query'.
Related skills
PostGIS Geospatial Development
Implements best practices for querying and managing geospatial data in PostgreSQL with PostGIS.
Database Management12 ptsSupabase Database Integration
Query and interact with Supabase databases using real-time subscriptions and PostgreSQL-compatible syntax while respecting Row Level Security policies.
Database Management12 ptsDatabase Connection Pooling
Optimizes database performance and reliability by configuring robust connection pools for SQLAlchemy across traditional and serverless architectures.
Database Management12 pts