sqlite

Execute SQL queries and non-query statements on local SQLite .db files.

2|1|Updated Mar 13, 2026

Search Tags:#database #cli #sqlite #sql #embedded #transactions #local

Ready to run

npx skills add https://github.com/robomotionio/robomotion-skills --skill sqlite-robomotionio

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sqlite
Source: https://github.com/robomotionio/robomotion-skills/tree/main/skills/sqlite
Command: npx skills add https://github.com/robomotionio/robomotion-skills --skill sqlite-robomotionio

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Local, serverless SQLite operations for embedded databases, enabling quick SQL execution and schema management without a separate database server.

Core Features & Use Cases

Execute SELECT, INSERT, UPDATE, and DELETE statements against local .db files.
Support batch transactions and basic schema operations without a remote server.
Two usage modes: Stateless per-command execution and Stateful session via connect/disconnect for multiple operations.

Quick Start

Run a simple query against a local SQLite database file to retrieve results.

Frequently Asked Questions about sqlite

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

FAQPage Schema

How do I execute SQLite queries on a local database file without a server?▼

You can execute SQLite queries directly on local .db files using a serverless, embedded database approach. This allows fast SQL execution for SELECT, INSERT, UPDATE, and DELETE statements without needing a separate remote database server.

Can I run batch transactions and manage schema operations on an embedded database?▼

Yes, batch transactions and basic schema management are supported for embedded databases. You can apply multiple SQL operations efficiently in a single transaction while managing your local database schema without a remote server.

What is the difference between stateless per-command mode and stateful session mode for SQLite?▼

Stateless per-command mode executes individual SQL statements independently, while stateful session mode uses connect and disconnect operations to maintain a persistent connection for running multiple sequential queries against the database.

Do I need to install a separate database server to use local SQLite operations?▼

No, you do not need a separate database server. Local SQLite operations enable serverless data management by interacting directly with embedded .db files, satisfying requirements for standalone usage and fast data operations.

Are there limitations when using serverless SQLite for local data operations?▼

Serverless SQLite is designed for standalone, local usage rather than networked client access. Limitations include lacking built-in concurrency control for simultaneous external writes, as it operates directly on local embedded .db files.

When should I use a stateful session connection for SQLite queries?▼

Use a stateful session connection when you need to execute multiple related SQLite queries sequentially. By using connect and disconnect, you maintain a persistent state for complex batch transactions, avoiding the overhead of reconnecting per command.