SQ

    SQLite — query, change, and back up local databases

    1

    Query, change, and back up a local SQLite database with the sqlite3 CLI — use when the data already lives in a .db file.

    Free

    2 usesSecurity scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    About this skill

    This skill works on a local SQLite database file with the sqlite3 CLI — enough for inspection, one-off queries, writes, and backups. When a value comes from outside the command you typed, it switches to Python's stdlib sqlite3 module and binds the value with a ? placeholder instead of concatenating text into SQL.

    The everyday commands are covered: create a table, insert, and read back with -json so rows come out in a shape an agent can parse; .tables and .schema to see what is in a file; and session pragmas, with the big one called out — PRAGMA foreign_keys defaults to 0 in SQLite, so any connection that should enforce foreign keys must turn it on explicitly.

    Backups are done properly: the CLI's .backup command copies a live database including its WAL pages, verified afterward with PRAGMA integrity_check (which prints ok on a consistent copy). Copying the file with cp can catch a WAL database mid-write, so the skill forbids it as a backup method.

    Also covered: --safe mode for running an untrusted SQL script so it cannot shell out or load extensions, the rowid behavior of INTEGER PRIMARY KEY, and installation (sqlite3 ships on macOS and many Linux systems; the sqlite3 package on Debian/Ubuntu, Homebrew for a newer build). Scope is explicit: this covers single-file databases, not client/server databases.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    2 uses

    Times used to date

    Free forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 1 month ago

    • Free with an Agensi account

    Requires

    GitHub
    Pages
    W3
    Schema
    Opensource

    Permissions

    Network Access

    Allowed Hosts

    honeypot-e6c.pages.dev
    www.w3.org
    schema.org
    github.com
    opensource.org
    raw.githubusercontent.com
    Listed1 month ago

    What's inside

    Frequently Asked Questions

    Query, change, and back up a local SQLite database with the sqlite3 CLI — use when the data already lives in a .db file.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use SQLite — query, change, and back up local databases on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.

    Free