db

Automate cross-database queries and schema management across SQLite, PostgreSQL, and MySQL.

24|6|Updated Dec 19, 2025
One-click install
npx skills add https://github.com/johnlindquist/claude --skill db
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db
Source: https://github.com/johnlindquist/claude/tree/main/skills/db
Command: npx skills add https://github.com/johnlindquist/claude --skill db

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite3, postgresql-client, mysql-client, and includes scripts (resource) components.

What problem does it solve?

This Skill eliminates manual database administration work, allowing you to query, inspect schemas, and generate AI-assisted queries across SQLite, PostgreSQL, and MySQL.

Core Features & Use Cases

  • Query & Schema Management: Execute queries, inspect database structures, and manage migrations across multiple database systems.
  • AI-Powered Query Generation: Use Gemini to write complex SQL queries based on natural language descriptions.
  • Use Case: Imagine you need to analyze user signups and purchases. Use this Skill to automatically generate and execute optimized SQL queries.

Quick Start

Query the users table in the production database to find recent active customers.

Frequently Asked Questions about db

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

FAQPage Schema
How do I query multiple databases like SQLite, PostgreSQL, and MySQL from the command line?

Execute queries across SQLite, PostgreSQL, and MySQL using environment variable-based connections (DATABASE_URL, SQLITE_DB). The Skill routes queries to the correct database system and returns results directly, eliminating manual connection switching.

Can I generate SQL queries from natural language descriptions?

Yes, the Skill uses Gemini to generate SQL queries from natural language. Describe what you need—like analyzing user signups—and it writes, explains, and executes optimized queries across your database.

How do I inspect database schemas and run migrations safely?

Schema inspection reveals table structures, columns, and relationships across databases. The Skill supports safe migration workflows via CLI, letting you preview changes and apply them with confidence across development and production environments.

Does this work for ad-hoc queries in development and testing environments?

Yes, the Skill is designed for development, testing, and lightweight production environments. It excels at ad-hoc queries, schema inspection, and one-off analysis without requiring persistent infrastructure.

Can I export data from my database and view execution plans?

The Skill supports data export to multiple formats and generates explain plans to show how queries execute. This lets you optimize queries and audit database performance across SQLite, PostgreSQL, and MySQL.

What databases does this support, and do I need clients installed?

Supports SQLite, PostgreSQL, and MySQL. The Skill requires sqlite3, postgresql-client, and mysql-client as CLI dependencies, which you install once to enable cross-database operations.