sqlite-query

A read-only helper for exploring SQLite databases, which are self-contained database files. It can inspect database structure, run supported SQL queries, and show how the database plans to execute a query.

In plain words
What is it for?
Use it to list database files, inspect tables and columns, view data with SELECT queries, and check query plans with EXPLAIN.
Why use it?
It removes the need to switch between separate database tools when examining local SQLite data. Read-only operation helps prevent accidental changes while investigating or optimizing queries.

Skill for Claude CodeCodex

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add skills/ofershap/mcp-server-sqlite/sqlite-query
Any agent
npx skills add ofershap/mcp-server-sqlite --skill sqlite-query
Clone the repo
git clone --depth 1 https://github.com/ofershap/mcp-server-sqlite

Made for: Claude Code, Codex.

Per session 24 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 392 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00024 $0.00392
Opus 5 $0.00012 $0.00196
Sonnet 5 $0.00005 $0.00078
Haiku 4.5 $0.00002 $0.00039

Measured yesterday against content hash d48d502329da, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

sqlite-query scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured yesterday.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/sqlite-query/SKILL.md · 41 lines

What it actually says

SQLite Query via MCP

Use this skill when you need to query SQLite databases, inspect schemas, or optimize queries. Read-only by default for safety.

Available Tools

Tool What it does
query Execute SQL (SELECT, PRAGMA, EXPLAIN, WITH). Returns results as a table.
schema Full schema: all tables with columns, types, and row counts
table_info Detailed info for a single table: columns, constraints, row count
explain Run EXPLAIN QUERY PLAN for query optimization
list_databases List .db, .sqlite, .sqlite3 files in a directory

Workflow

  1. list_databases to find .db files in the project
  2. schema to understand the full database structure
  3. table_info for detailed column info on specific tables
  4. query to run SELECT queries and inspect data
  5. explain to optimize slow queries

Key Patterns

  • Read-only by default — only SELECT, PRAGMA, EXPLAIN, and WITH are allowed
  • Pass readonly: false in tool args to enable INSERT, UPDATE, DELETE
  • schema returns everything at once — use it first to understand the database
  • query returns tabular results — ideal for exploration and debugging
  • Database path is passed per-tool call, not globally configured

Safety

  • Read-only mode is on by default — no accidental mutations
  • Confirm with the user before enabling write mode (readonly: false)
  • Large result sets are truncated — use LIMIT in queries for efficiency
Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. yesterday First seen · 41 lines · 24 tokens per session scan A d48d502329da

Subscribe to this mod's changes

sqlite-query is a skill published in the GitHub repository ofershap/mcp-server-sqlite (3 stars, last pushed 5mo ago), licensed MIT. It adds 24 tokens to every session and 392 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Related

Other skills, from other repositories

auth-web-cloudbase

CloudBase Web Authentication Quick Guide for frontend integration after auth-tool has already been checked. Provides concise and practical Web authentication solutions with multiple login methods and complete user management.

TencentCloudBase/CloudBase-AI-Toolkit · 38 tokens

fix-codesign-error

Slash command that inspects a macOS signing or entitlement failure and explains the minimum fix path. Invoke explicitly with /fix-codesign-error — this skill never self-triggers.

robinebers/openusage · 42 tokens

browse-and-evaluate

Use when exploring the ai-agent-skills catalog to find, compare, and evaluate skills before installing. Always use --fields to limit output size and --dry-run before committing to an install.

MoizIbnYousaf/Ai-Agent-Skills · 43 tokens

specflow-use

To connect Rosetta with Grid Dynamics SpecFlow MCP; only when SpecFlow is mentioned and the MCP is installed.

griddynamics/rosetta · 27 tokens

loop-engineering

Shared loop-engineering reference for COG skills - the agent loop, deterministic verifiers, termination conditions, in-loop context management, and named patterns. Invoke when designing or debugging a skill that iterates (search-verify-retry, scan-until-dry, fetch-retry-gate).

huytieu/COG-second-brain · 63 tokens

telnyx-messaging-hosted-curl

Set up hosted SMS numbers, toll-free verification, and RCS messaging. Use when migrating numbers or enabling rich messaging features. This skill provides REST API (curl) examples.

team-telnyx/ai · 45 tokens