SQLite Reference
The most used database in the world.
Commands
| Command | Description |
|---|---|
intro |
Overview, limits, CLI |
sql |
JSON, windows, CTE, FTS5 |
python |
Python, pragmas, backup |
Sqlite
SQLite embedded database reference. The most-used database engine in the world. Covers CLI, JSON functions, window functions, CTEs, FTS5 full-text search, UPSERT, Python stdlib integration, WAL mode performance tuning, pragmas, backup, and import/export.
bytesagain
Updated Sqlite by bytesagain · f01c5fa
npx skillmds@latest add bytesagain/sqlite File contents
---name: sqlitedescription: SQLite embedded database reference. The most-used database engine in the world. Covers CLI, JSON functions, window functions, CTEs, FTS5 full-text search, UPSERT, Python stdlib integration, WAL mode performance tuning, pragmas, backup, and import/export.---# SQLite ReferenceThe most used database in the world.## Commands| Command | Description ||---------|-------------|| `intro` | Overview, limits, CLI || `sql` | JSON, windows, CTE, FTS5 || `python` | Python, pragmas, backup |
bytesagain/ai-skills/tree/main/sqlite commit f01c5fa287
Frequently asked questions
Run npx skillmds@latest add bytesagain/sqlite in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
SQLite embedded database reference. The most-used database engine in the world. Covers CLI, JSON functions, window functions, CTEs, FTS5 full-text search, UPSERT, Python stdlib integration, WAL mode performance tuning, pragmas, backup, and import/export. It is listed under Integrations & APIs on SkillMD.
This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
bytesagain (@bytesagain) published this skill. Their other Agent Skills are listed on their SkillMD profile.