cli-sqlite

Operate SQLite as a serverless embedded database for local data tasks.

3|1|Updated Mar 27, 2026
One-click install
npx skills add https://github.com/ryankolean/summit-claude-skills --skill cli-sqlite
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: cli-sqlite
Source: https://github.com/ryankolean/summit-claude-skills/tree/main/skills/cli-sqlite
Command: npx skills add https://github.com/ryankolean/summit-claude-skills --skill cli-sqlite

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQLite provides a serverless, embedded SQL database that eliminates the overhead of running a separate database server, enabling fast local data experiments, prototyping, and tiny apps.

Core Features & Use Cases

  • CLI power user: leverage sqlite3 dot-commands for quick database exploration and schema management.
  • Data interchange: import/export CSV and JSON for seamless data movement across tools.
  • Advanced capabilities: utilize FTS5 full-text search, WAL mode, and multi-database ATTACH for complex workflows.
  • Use Case: prototype an embedded analytics workflow by attaching multiple databases and running ad-hoc queries without managing a server.

Quick Start

Run a quick local query against your database to verify the connection and schema.

Frequently Asked Questions about cli-sqlite

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

FAQPage Schema
How do I run SQL queries on CSV or JSON files without setting up a database server?

Use SQLite as a serverless, embedded database to import CSV or JSON files directly and run ad-hoc SQL queries without managing a separate database server.

Can I attach multiple SQLite databases together for cross-database analysis?

Yes, SQLite supports multi-database ATTACH functionality, allowing you to attach multiple databases simultaneously and run cross-database queries for embedded analytics workflows.

How does FTS5 full-text search work in a local SQLite database?

FTS5 is an advanced full-text search capability supported in SQLite, allowing you to perform fast text searches on local data within lightweight environments without external search servers.

What are the best ways to explore database schemas using SQLite CLI dot-commands?

SQLite CLI dot-commands provide quick database exploration and schema management capabilities, allowing you to inspect tables, structures, and relationships directly from the command line interface.

When should I use WAL mode in SQLite for local data tasks?

WAL mode in SQLite optimizes concurrent access and transaction performance for local data tasks, making it suitable for lightweight environments and rapid prototyping workflows.