# SQLite

> Use this tool when you need to query and inspect SQLite databases in a safe and controlled manner. It solves problems related to data analysis, schema inspection, and query optimization, and provides inputs such as SQL statements and database files, with outputs including query results and table information. Ideal for use cases where read-only access is preferred, with optional write access available when necessary.

Canonical page: https://skillsregistry.net/skills/gh-ofershap-sqlite  
JSON: https://api.skillsregistry.net/v1/skills/gh-ofershap-sqlite

## Description

Enables querying SQLite databases with read-only default mode for safety. Supports SELECT, PRAGMA, EXPLAIN, and WITH statements, schema inspection for all tables with columns and types, detailed table information, query optimization via EXPLAIN QUERY PLAN, and database file discovery across directories. Optional write access available when needed.

## Trust

- **Trust score (0–1):** 0.97
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-28

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/gh-ofershap-sqlite)
- **Repository:** <https://github.com/ofershap/mcp-server-sqlite>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "gh-ofershap-sqlite"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/gh-ofershap-sqlite` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/gh-ofershap-sqlite/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt