skills.rest
DJVdio
DJVdioCOMMUNITY
Explore all skills by this author →
GitHub

db-ops

Execute MySQL database operations with step-by-step risk analysis.

Updated Apr 20, 2026
Search Tags:#security#mysql#database operations#risk analysis#sql execution
One-click install
npx skills add https://github.com/DJVdio/claude-tools --skill db-ops
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-ops
Source: https://github.com/DJVdio/claude-tools/tree/main/skills/db-ops
Command: npx skills add https://github.com/DJVdio/claude-tools --skill db-ops

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pymysql, PyYAML, sqlparse, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill ensures secure MySQL database operations, guiding users through a step-by-step risk analysis process before executing SQL commands.

Core Features & Use Cases

  • Secure Database Access: Connects to TEST and PROD databases safely.
  • Step-by-Step Execution: Requires users to follow a three-step process for all operations.
  • Risk Analysis: Provides risk analysis and confirmation before executing SQL commands.
  • Use Case: Ideal for developers or DBAs needing to perform SQL operations on a MySQL database, ensuring security and minimizing risks.

Quick Start

Run the 'db-ops' skill and follow the prompts to execute a SQL command.

Frequently Asked Questions about db-ops

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I perform secure MySQL database operations with risk analysis before execution?▼

Secure MySQL database operations require a step-by-step risk analysis process to evaluate SQL commands before execution. This ensures query, modify, insert, update, or delete operations are reviewed for risks and require confirmation.

What's the best way to analyze SQL execution risks for MySQL production databases?▼

Analyzing SQL execution risks for MySQL databases involves a three-step execution process that provides risk assessment and confirmation prompts before executing commands on TEST or PROD environments.

Do I need pymysql and sqlparse to execute SQL commands on a MySQL database?▼

Yes, executing SQL commands with risk analysis requires pymysql for database connectivity, sqlparse for SQL parsing, and PyYAML for configuration. These dependencies enable secure query, modify, and delete operations.

Can I use this approach for both TEST and PROD MySQL database environments?▼

Yes, secure database access supports connecting to both TEST and PROD MySQL databases. It applies step-by-step risk analysis to all SQL operations, ensuring safety across different environments.

How does step-by-step execution prevent accidental data loss during MySQL updates?▼

Step-by-step execution prevents accidental data loss by enforcing a three-step process that analyzes SQL risks and requires explicit user confirmation before applying update or delete operations to the database.

Related Skills

Explore More Software Engineering Skills→
KatsumitecKatsumitec

run-sql

Execute MySQL SQL scripts sequentially with dry run and error handling options.

Official
Intermediate
mbpzmbpz

relational-database-mcp-cloudbase

Automate SQL execution and MySQL instance management for CloudBase Relational Database via MCP.

Community
Advanced
KatsumitecKatsumitec

extract-channel

Extract payment channel configurations from MySQL into SQL, Markdown, and FTL files.

Official
Advanced
Orvanta-CloudOrvanta-Cloud

write-script-mysql

Create, preview, and execute MySQL query scripts programmatically.

Official
Basic