query-sqlite-db

Inspect SQLite databases with sqlite3 commands for schema and sample queries.

Updated Dec 28, 2025

Search Tags:#debugging #troubleshooting #database #sqlite #sql #sqlite3

Ready to run

npx skills add https://github.com/mcsdodo/kniha-jazd --skill query-sqlite-db

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: query-sqlite-db
Source: https://github.com/mcsdodo/kniha-jazd/tree/main/.claude/skills/query-sqlite-db
Command: npx skills add https://github.com/mcsdodo/kniha-jazd --skill query-sqlite-db

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Inspect and debug the application's SQLite database to diagnose data issues, with a reminder to use full paths because environment variables don't expand in bash.

Core Features & Use Cases

Direct, ad-hoc queries against core tables such as vehicles, trips, and receipts to surface data state and relationships.
Quick reference of common commands to inspect schema and tables and to fetch sample rows for debugging.
Clear guidance for environments (dev and prod) and path resolution to ensure queries run reliably.

Quick Start

Run sqlite3 with the full path to the database and the desired query.

Frequently Asked Questions about query-sqlite-db

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

FAQPage Schema

How do I inspect an SQLite database to troubleshoot data issues?▼

To inspect an SQLite database and troubleshoot data issues, run sqlite3 with the full path to your database file. This allows you to execute ad-hoc queries against core tables like vehicles, trips, and receipts to surface data states and relationships.

Why does my sqlite3 command fail to find the database in bash?▼

Your sqlite3 command fails because environment variables do not expand in bash. You must provide the full absolute path to the SQLite database file instead of relying on variables to ensure queries run reliably in both dev and prod environments.

What is the best way to query core tables like trips and receipts in SQLite?▼

The best way to query core tables like trips and receipts in SQLite is by using ready-to-run sqlite3 commands for schema inspection and sample queries. This provides clear guidance for fetching rows and diagnosing data relationships across environments.

Can I use sqlite3 commands to check schema and sample rows for debugging?▼

Yes, you can use sqlite3 commands to check schema and sample rows for debugging. The Skill provides quick reference commands to inspect table schemas and fetch sample data, helping you diagnose data issues directly in development or production.

Does this SQLite debugging approach work in both development and production environments?▼

Yes, this SQLite debugging approach works in both development and production environments. It provides clear guidance for environment path resolution to ensure your ad-hoc queries against core tables run reliably without environment variable expansion.