sqlite-clientSQLite database operations. Use this skill when users need to create, read, query, or modify SQLite databases (.db files).
Install via ClawdBot CLI:
clawdbot install openlark/sqlite-clientGrade Limited — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Potentially destructive shell commands in tool definitions
exec(Audited Apr 21, 2026 · audit v1.0
Generated Oct 6, 2026
Desktop applications such as note-taking, inventory, or accounting tools store user data in local .db files using this skill. Developers use the cached driver and prepared statements to ensure fast, reliable reads and writes without a server. WAL mode keeps concurrent writes safe while the user works offline.
Teams building MVPs or proof-of-concepts spin up ':memory:' databases to test schemas, queries, and business logic in seconds. The same sqlite library API works for both in-memory and file-based databases, so code moves to production with minimal changes. This shortens iteration cycles for startups validating ideas.
Analysts receive .db files from third-party tools, mobile apps, or IoT devices and need to inspect their contents. Using utility queries like sqlite_master and PRAGMA table_info, they list tables, inspect schemas, and count rows without specialized database software. Results can then be exported for reporting or visualization.
Edge gateways and IoT controllers use SQLite to log sensor readings and device state locally due to its tiny footprint and zero-configuration nature. This skill provides the query and migration patterns to structure that data reliably. When connectivity returns, the data is synced to a cloud backend.
Small Node.js web services and CLI tools use the migrations feature to version-control schema changes across environments. Sequential SQL files like 001-init.sql are applied automatically, keeping development, staging, and production databases in sync. The force option enables controlled rollbacks during development.
Maintainers of SQLite client libraries, ORMs, and migration frameworks offer the core package freely while monetizing enterprise features, support contracts, or hosted sync services. Adoption grows through developer communities and integration guides like this skill.
Applications deliver a cloud dashboard but store primary working data locally in SQLite for speed and offline capability, reducing server costs. Users pay a monthly subscription for collaboration, backup, and cross-device sync features. This hybrid architecture improves performance while creating recurring revenue.
Consultancies extract, analyze, and migrate client data locked inside SQLite files from legacy or third-party applications. They deliver reports, dashboards, and migration pipelines built on the same sqlite client patterns. This creates project-based and retainer revenue from data modernization work.
💬 Integration Tip
Install sqlite3 and sqlite via npm before any operations, and always finalize prepared statements to avoid memory leaks. Use the cached driver for repeated access to the same .db file and enable WAL mode if concurrent writes are expected.
Scored Apr 21, 2026
Database Designer - POWERFUL Tier Skill
Skill Oracle — Curated documentation of quality ClawHub skills. Markdown tables telling agents which tools work and which are empty. Not an API or code library.
Database Schema Designer
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
Pinecone vector database — manage indexes, upsert vectors, query similarity search, manage namespaces, and track collections via the Pinecone API. Build sema...
Connect, query, and monitor Redis instances. Use when checking key health, validating data types, generating backups, formatting results, linting configs.