# 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.

- Skill: `bytesagain/sqlite` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add bytesagain/sqlite`
- Raw SKILL.md: https://api.skillmd.com/api/skills/bytesagain/sqlite/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Integrations & APIs
- Author: bytesagain (https://skillmd.com/u/bytesagain)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/bytesagain/sqlite

---


# 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 |