{"id":"1db0de89-dcc4-43dd-ae09-a3b0c52a5964","shortId":"tKAwR5","kind":"skill","title":"sqlite-utils Python CLI for SQLite Database Manipulation","tagline":"sqlite-utils is a Python CLI utility and library by Simon Willison for manipulating SQLite databases. It lets you pipe JSON, CSV, or TSV data directly into SQLite, run in-memory SQL queries against files, configure full-text search, and perform schema transformations — all from t","description":"# sqlite-utils Python CLI for SQLite Database Manipulation\n\nsqlite-utils is a Python CLI utility and library by Simon Willison for manipulating SQLite databases. It lets you pipe JSON, CSV, or TSV data directly into SQLite, run in-memory SQL queries against files, configure full-text search, and perform schema transformations — all from the command line.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- pip install sqlite-utils\n- brew install sqlite-utils\n\nRequirements and caveats from upstream:\n- [![Python 3.x](https://img.shields.io/pypi/pyversions/sqlite-utils.svg?logo=python&logoColor=white)](https://pypi.org/project/sqlite-utils/)\n- Python CLI utility and library for manipulating SQLite databases.\n- You can also import sqlite_utils and use it as a Python library like this:\n\nBasic usage or getting-started notes:\n- [Run in-memory SQL queries](https://sqlite-utils.datasette.io/en/stable/cli.html#querying-data-directly-using-an-in-memory-database), including joins, directly against data in CSV, TSV or JSON files and view the results\n- [Configure SQLite full-text search](https://sqlite-utils.datasette.io/en/stable/cli.html#configuring-full-text-search) against your database tables and run search queries against them, ordered by relevance\n- Run [transformations against your tables](https://sqlite-utils.datasette.io/en/stable/cli.html#transforming-tables) to make schema changes that SQLite ALTER TABLE does not directly support, such as changing the type o...\n\n- Source: https://github.com/simonw/sqlite-utils\n- Extracted from upstream docs: https://raw.githubusercontent.com/simonw/sqlite-utils/HEAD/README.md\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/sqlite-utils-python-cli-sqlite-manipulation/)","tags":["sqlite","utils","python","cli","manipulation","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code"],"capabilities":["skill","source-agentskillexchange","skill-sqlite-utils-python-cli-sqlite-manipulation","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/sqlite-utils-python-cli-sqlite-manipulation","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,792 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:12:36.113Z","embedding":null,"createdAt":"2026-05-18T13:19:35.924Z","updatedAt":"2026-05-18T19:12:36.113Z","lastSeenAt":"2026-05-18T19:12:36.113Z","tsv":"'/en/stable/cli.html#configuring-full-text-search)':215 '/en/stable/cli.html#querying-data-directly-using-an-in-memory-database),':191 '/en/stable/cli.html#transforming-tables)':236 '/pypi/pyversions/sqlite-utils.svg?logo=python&logocolor=white)](https://pypi.org/project/sqlite-utils/)':151 '/simonw/sqlite-utils':258 '/simonw/sqlite-utils/head/readme.md':265 '/skills/sqlite-utils-python-cli-sqlite-manipulation/)':272 '3':147 'agent':267 'agentskillexchange.com':271 'agentskillexchange.com/skills/sqlite-utils-python-cli-sqlite-manipulation/)':270 'also':163 'alter':243 'basic':176 'brew':136 'caveat':143 'chang':240,251 'cli':5,16,63,74,153 'command':117 'configur':47,105,207 'csv':32,90,198 'data':35,93,196 'databas':8,26,66,84,160,218 'direct':36,94,194,247 'doc':262 'environ':130 'exchang':269 'extract':259 'file':46,104,202 'full':49,107,210 'full-text':48,106,209 'get':180 'getting-start':179 'github.com':257 'github.com/simonw/sqlite-utils':256 'img.shields.io':150 'img.shields.io/pypi/pyversions/sqlite-utils.svg?logo=python&logocolor=white)](https://pypi.org/project/sqlite-utils/)':149 'import':164 'in-memori':40,98,184 'includ':192 'instal':119,123,132,137 'join':193 'json':31,89,201 'let':28,86 'librari':19,77,156,173 'like':174 'line':118 'make':238 'manipul':9,24,67,82,158 'match':128 'memori':42,100,186 'note':182 'o':254 'order':226 'path':126 'perform':53,111 'pip':131 'pipe':30,88 'python':4,15,62,73,146,152,172 'queri':44,102,188,223 'raw.githubusercontent.com':264 'raw.githubusercontent.com/simonw/sqlite-utils/head/readme.md':263 'relev':228 'requir':141 'result':206 'run':39,97,183,221,229 'schema':54,112,239 'search':51,109,212,222 'setup':125 'simon':21,79 'skill':268 'skill-sqlite-utils-python-cli-sqlite-manipulation' 'sourc':255,266 'source-agentskillexchange' 'sql':43,101,187 'sqlite':2,7,11,25,38,60,65,69,83,96,134,139,159,165,208,242 'sqlite-util':1,10,59,68,133,138 'sqlite-utils.datasette.io':190,214,235 'sqlite-utils.datasette.io/en/stable/cli.html#configuring-full-text-search)':213 'sqlite-utils.datasette.io/en/stable/cli.html#querying-data-directly-using-an-in-memory-database),':189 'sqlite-utils.datasette.io/en/stable/cli.html#transforming-tables)':234 'start':181 'support':248 'tabl':219,233,244 'text':50,108,211 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'transform':55,113,230 'tsv':34,92,199 'type':253 'upstream':122,145,261 'usag':177 'use':120,168 'util':3,12,17,61,70,75,135,140,154,166 'view':204 'willison':22,80 'x':148","prices":[{"id":"cecffd09-fa10-415b-8f54-b5a6d99df7f0","listingId":"1db0de89-dcc4-43dd-ae09-a3b0c52a5964","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:19:35.924Z"}],"sources":[{"listingId":"1db0de89-dcc4-43dd-ae09-a3b0c52a5964","source":"github","sourceId":"agentskillexchange/skills/sqlite-utils-python-cli-sqlite-manipulation","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/sqlite-utils-python-cli-sqlite-manipulation","isPrimary":false,"firstSeenAt":"2026-05-18T13:19:35.924Z","lastSeenAt":"2026-05-18T19:12:36.113Z"}],"details":{"listingId":"1db0de89-dcc4-43dd-ae09-a3b0c52a5964","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"sqlite-utils-python-cli-sqlite-manipulation","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"3624f407ce22dd81dc7c1b3dbd818c57706018dc","skill_md_path":"skills/sqlite-utils-python-cli-sqlite-manipulation/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/sqlite-utils-python-cli-sqlite-manipulation"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"sqlite-utils Python CLI for SQLite Database Manipulation","description":"sqlite-utils is a Python CLI utility and library by Simon Willison for manipulating SQLite databases. It lets you pipe JSON, CSV, or TSV data directly into SQLite, run in-memory SQL queries against files, configure full-text search, and perform schema transformations — all from the command line."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/sqlite-utils-python-cli-sqlite-manipulation"},"updatedAt":"2026-05-18T19:12:36.113Z"}}