skills.rest
XSpoonAi
XSpoonAiOFFICIAL
Explore all skills by this author →
WebsiteGitHub

db-sql-runner

Executes parameterized SQL queries across SQLite, PostgreSQL, and MySQL with JSON output.

17|45|Updated Jan 23, 2026
Search Tags:#database#postgresql#sqlite#sql#mysql#parameterized-queries#dev-mode
One-click install
npx skills add https://github.com/XSpoonAi/spoon-awesome-skill --skill db-sql-runner
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-sql-runner
Source: https://github.com/XSpoonAi/spoon-awesome-skill/tree/main/ai-productivity/db-sql-runner
Command: npx skills add https://github.com/XSpoonAi/spoon-awesome-skill --skill db-sql-runner

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2, mysql-connector-python, and includes scripts (resource) components.

What problem does it solve?

Running ad-hoc SQL across multiple databases securely requires careful parameter handling and consistent results. This Skill provides a unified CLI to execute parameterized queries against SQLite, PostgreSQL, and MySQL with safe bindings and dev-mode safeguards.

Core Features & Use Cases

  • Safe parameter binding across SQLite, PostgreSQL, and MySQL
  • Demo mode with an in-memory SQLite database for quick testing
  • Cross-dialect results in JSON for easy integration and validation

Quick Start

Invoke the CLI with a JSON payload to execute a parameterized query against your configured database.

Frequently Asked Questions about db-sql-runner

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

FAQPage Schema
How do I run parameterized SQL queries across SQLite, PostgreSQL, and MySQL safely?▼

You can execute parameterized SQL queries across SQLite, PostgreSQL, and MySQL safely using a unified CLI that applies safe parameter binding and automatic placeholder translation across different database dialects.

What is the best way to test SQL queries without connecting to a live database?▼

Using demo mode with an in-memory SQLite database allows you to test SQL queries without connecting to a live database, providing a quick and isolated environment for development and cross-dialect validation.

Do I need psycopg2 and mysql-connector-python to query PostgreSQL and MySQL?▼

Yes, you need psycopg2 for PostgreSQL and mysql-connector-python for MySQL. The CLI gracefully handles missing drivers, but these dependencies are required to execute parameterized queries against their respective databases.

How do I get JSON output from SQL queries for data exploration?▼

You can get JSON output from SQL queries by executing parameterized statements through the CLI, which formats cross-dialect results into JSON for easy integration, data exploration, and validation.

Does dev-mode provide safeguards when running SQL during development?▼

Dev-mode provides optional development safeguards when running SQL, helping to prevent accidental data modification or unsafe query execution during testing and data exploration sessions.

Related Skills

Explore More Software Engineering Skills→
saajunaidsaajunaid

db-testing

Diagnose database connectivity and validate query execution across PostgreSQL, MySQL, and SQL Server.

Community
Intermediate
gman-roboticsgman-robotics

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Official
Intermediate
hgflimahgflima
1

ci-cd-and-automation

Automate CI/CD pipeline setup with quality gates, testing, and deployment strategies.

Community
Advanced
marquesfelipmarquesfelip

sql-injection-prevention

Identify and fix SQL injection vulnerabilities in data access layers.

Community
Advanced