sqlite-queries
OfficialSQLite queries made simple: read and write.
Authortheslashdojo
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Enables agents to perform and reason about SQLite data operations, unifying read/write tasks in a single, reliable interface.
Core Features & Use Cases
- Supports SELECT queries with joins, filters, aggregations, and sorts for data retrieval.
- Handles INSERT, UPDATE, DELETE, and UPSERT (ON CONFLICT) for consistent data mutations.
- Includes Common Table Expressions (CTEs), JSON queries, window functions, and transactional patterns for advanced analytics and workflows.
- Provides guidance on parameterized queries to prevent SQL injection and ensure safe data access.
Quick Start
Execute the included script against a local SQLite database to see SELECT, INSERT, UPDATE, DELETE, UPSERT, CTEs, JSON, and transactions in action.
Dependency Matrix
Required Modules
sqlite3
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sqlite-queries Download link: https://github.com/theslashdojo/dojo/archive/main.zip#sqlite-queries Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.