Does it support different output formats for reports?

Yes, the skill covers various SQLite CLI output modes including column, CSV, JSON, and markdown to make query results more readable or exportable.

Can I use this skill to optimize slow SQL queries?

Yes, it provides specific guidance on using EXPLAIN QUERY PLAN, creating indexes, and utilizing PRAGMA optimizations to diagnose and fix performance bottlenecks.

When should I use this skill instead of a general SQL skill?

Use this skill when you are working specifically with the SQLite CLI, as it focuses on SQLite-unique syntax (like STRFTIME) and CLI-specific commands (.import, .mode, .schema).

How does this skill handle data import verification?

The skill includes standardized verification patterns to check row counts, sample data, and null values immediately after a CSV import to prevent data loss or corruption.

What is the primary purpose of the using-sqlite skill?

It provides task-oriented guidance for common SQLite operations such as schema exploration, data importing, and query optimization specifically for data analysis workflows.

SQLite Data Analysis & Management

Name: SQLite Data Analysis & Management
Author: tilmon-engineering

bytilmon-engineering

•

数据库管理

Streamlines SQLite database operations for data analysis through expert guidance on schema exploration, efficient querying, and data importing.

The Using-SQLite skill provides a structured framework for interacting with SQLite databases during DataPeeker analysis sessions. It moves beyond basic SQL by offering task-oriented patterns for exploring unfamiliar schemas, formatting CLI output for maximum readability, and implementing SQLite-specific idioms like STRFTIME for date handling. Designed to prevent common pitfalls like integer division errors or silent import failures, it includes robust verification steps and performance optimization techniques using EXPLAIN QUERY PLAN to ensure analysis is both accurate and efficient.

主要功能

01Structured CSV-to-SQLite import workflows with data verification

02Standardized patterns for CLI invocation and multi-command scripts

03Comprehensive schema exploration and table structure discovery

04CLI output formatting for readability (column, CSV, JSON, and markdown modes)

05SQLite-specific query optimization and performance analysis

062 GitHub stars

使用场景

01Exploring and profiling unfamiliar datasets in local SQLite databases

02Loading and verifying large CSV files for structured analytical workflows

03Optimizing slow-running analytical queries through indexing and plan analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add tilmon-engineering/claude-skills using-sqlite

For use in Claude.ai and ChatGPT

Download Skill