Using Sqlite
Use when working with SQLite databases in DataPeeker analysis sessions - querying data, importing CSVs, exploring schemas, formatting output, or optimizing performance. Provides task-oriented guidance for effective SQLite CLI usage in data analysis workflows.
Install
/plugin marketplace add tilmon-engineering/claude-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add tilmon-engineering/claude-skills --skill using-sqlitegit clone --depth 1 https://github.com/tilmon-engineering/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/plugins/datapeeker/skills/using-sqlite ~/.claude/skills/using-sqlitePersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Using SQLite ## Overview SQLite is the primary database for DataPeeker analysis sessions. This skill provides task-oriented guidance for common SQLite operations during data analysis. **Core principle:** Explore schema first, format output for readability, write efficient queries, verify all operations. ## When to Use Use this skill when you need to: - Explore an unfamiliar database schema - Query data for analysis or hypothesis testing - Import CSV files into SQLite tables - Format query output for readability - Diagnose slow queries or optimize performance - Understand which CLI invocation pattern to use **When NOT to use:** - Database-agnostic data profiling (see `understanding-data` skill for patterns that work across all SQL databases) - Complex data cleaning logic (delegate to `cleaning-data` skill + sub-agents) - Statistical analysis (use Python/pandas for advanced statistics) - Large-scale transformations (use Python sqlite3 module) ## DataPeeker Conventions ``` Database Path: data/analytics.db (relative from project root) Table Naming: raw_* for imported data, clean_* for cleaned data Single Database: All tables in one file per analysis session ``` **Example workflow:** ``` CSV file → raw_sales → clean_sales → Analysis queries ``` ## Quick Reference | Task | Guidance File | |------|---------------| | Understand what tables/columns exist | @./exploring-schema.md | | Make query results readable | @./formatting-output.md |
Details
- Skill name
using-sqlite- Repository
- tilmon-engineering/claude-skills
- Path
plugins/datapeeker/skills/using-sqlite/SKILL.md- License
- MIT
- Repo updated
- 22 May 2026
FAQ
What does the Using Sqlite skill do?
Use when working with SQLite databases in DataPeeker analysis sessions - querying data, importing CSVs, exploring schemas, formatting output, or optimizing performance. Provides task-oriented guidance for effective SQLite CLI usage in data analysis workflows.
How do I install the Using Sqlite skill?
Claude Code plugin: /plugin marketplace add tilmon-engineering/claude-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Using Sqlite popular?
It lives in tilmon-engineering/claude-skills, which has 5 GitHub stars and 2 forks.
Related skills
Analyze Branch
5tilmon-engineering/claude-skills
Use when analyzing another branch's iteration journals to extract findings, decisions, and insights from divergent work
Branch Status
5tilmon-engineering/claude-skills
Use when user wants detailed status report for single autonomy branch including iteration timeline and metrics progression
Checkpoint Iteration
5tilmon-engineering/claude-skills
Use when saving current iteration progress mid-conversation, before context compaction, or at interim pause points
Using Typedb
5tilmon-engineering/claude-skills
Use when interacting with a TypeDB 3.x database via the typedb MCP tools (typedb-query, typedb-database_schema, etc.) - covers schema-first workflow, transaction types, TypeQL 3.x syntax (which differs materially from 2.x), and the most common failure modes
Importing Data
5tilmon-engineering/claude-skills
Systematic CSV import process - discover structure, design schema, standardize formats, import to database, detect quality issues (component skill for DataPeeker analysis sessions)
Accidental Data Loss Prevention
9huytran1120/vietnam-agentic-skills
**STOP AND VERIFY**: Before running any command or tool that results in irreversible data loss, you MUST obtain explicit user consent. When in doubt, ask. It is better to wait for confirmation than to accidentally delete production data or critical project assets. Use this for: - SQL: DROP TABLE/VIEW/SCHEMA/DATABASE, TRUNCATE, or broad DELETE (missing WHERE or using 1=1). - Cloud Storage: gsutil rm or gcloud storage rm targeting production data or critical buckets. - Infrastructure: gcloud projects delete, deleting Spanner/BigQuery/Dataproc resources, deleting secrets, or KMS key destruction.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.