Inspect SQLite databases with sqlite3 commands for schema and sample queries.
npx skills add https://github.com/mcsdodo/kniha-jazd --skill query-sqlite-db
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
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.
Run sqlite3 with the full path to the database and the desired query.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
soumyaraySearch ReadCube Papers library by title, author, year, or keyword and retrieve PDF paths.
CellCogAnalyze messy datasets to produce insights, charts, and data-driven reports.
parcadeiAnalyze application logs, SQLite databases, and git history to diagnose software issues.
xiaoyuge886Explore schemas, inspect tables, and execute SQL queries across multiple database engines.
