skills.rest
Birdywen
BirdywenCOMMUNITY
Explore all skills by this author →
GitHub

sqlite-data

Create, query, analyze, and export SQLite data via the sqlite3 CLI.

1|1|Updated Jan 21, 2026
Search Tags:#SQL#database#CLI#sqlite#data-analysis#import-export
One-click install
npx skills add https://github.com/Birdywen/genspark-agent --skill sqlite-data
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlite-data
Source: https://github.com/Birdywen/genspark-agent/tree/main/skills/sqlite-data
Command: npx skills add https://github.com/Birdywen/genspark-agent --skill sqlite-data

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQLite 数据库操作工具，提供一个便捷的命令行方案，用于创建、查询、分析以及导入导出数据，从而简化本地数据工作流.

Core Features & Use Cases

  • 基本数据库操作：打开/创建数据库、创建表、添加索引、查看结构和数据。
  • 数据分析与导出：执行聚合查询、导出为 CSV/JSON、生成 SQL dump，便于迁移与备份。
  • 轻量原型与本地存储：适用于小型项目、数据分析和快速验证 SQL 方案的场景。
  • 兼容性与组合使用：可与其他命令行工具（如 jq、各种文本处理工具）搭配，提升数据处理能力。

Quick Start

使用 sqlite3 命令对 database.db 进行创建、查询与导出，例如创建表、执行简单查询或将结果导出为 CSV。

Frequently Asked Questions about sqlite-data

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

FAQPage Schema
How do I export SQLite query results to CSV or JSON using the command line?▼

You can export SQLite query results to CSV or JSON by executing SQL commands through the sqlite3 CLI, enabling rapid data extraction and local data analysis for your database workflows.

What is the best way to create and manage a lightweight local database for rapid prototyping?▼

Creating a lightweight SQLite database is the best way to handle rapid prototyping and local data workflows, utilizing a single-file database to quickly create tables, add indexes, and validate SQL schemes.

Can I perform schema management and aggregation queries on a SQLite database via CLI?▼

Yes, you can perform schema management and execute aggregation queries on a SQLite database via the sqlite3 CLI, allowing you to view database structure and analyze data directly from the command line.

How do I generate a SQL dump for SQLite database backup and migration?▼

Generating a SQL dump for SQLite database backup and migration involves using the sqlite3 CLI to export your database structure and data, ensuring easy portability across local data workflows.

Does the SQLite database toolkit work with other command line text processing tools?▼

Yes, the SQLite database toolkit is compatible with other command line tools like jq and various text processing utilities, combining synergistically to enhance data processing and analysis capabilities.

When should I not use a single-file SQLite database for my data analysis tasks?▼

You should not use a single-file SQLite database for data analysis tasks that require heavy concurrent writes or large-scale network access, as it is optimized for lightweight local storage and rapid prototyping rather than enterprise-scale operations.

Related Skills

Explore More Data & Analytics Skills→
ryankoleanryankolean
3

cli-sqlite

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

Community
Intermediate
starlake-aistarlake-ai
209

parquet2csv

Convert Parquet files into CSV format for batch ETL pipelines.

Official
Intermediate
tedtv1007-ctrltedtv1007-ctrl

session-logs

Search and analyze local JSONL conversation history files with jq and ripgrep.

Community
Intermediate
Leonard-DataLeonard-Data

sqlite

Provide a serverless relational database with SQL queries and ACID transactions.

Community
Intermediate