# SQLite

> Use this tool when you need to securely manage databases with AI assistants, providing persistent data storage and enforcing directory-restricted access to prevent traversal attacks. It supports complete CRUD operations, transaction management, and database maintenance tools, making it ideal for applications requiring secure multi-database access. With SQLite, AI agents can perform secure database operations, creating and managing databases dynamically while ensuring security compliance.

Canonical page: https://skillsregistry.net/skills/liliang-cn-sqlite  
JSON: https://api.skillsregistry.net/v1/skills/liliang-cn-sqlite

## Description

SQLite MCP server by liliang-cn that provides AI assistants with secure database operations through directory-restricted access to SQLite databases. Built with Go using the mcp-go library and mattn/go-sqlite3 driver, the implementation supports multi-database switching, complete CRUD operations, transaction management, index creation with advanced options, and database maintenance tools like VACUUM and query analysis. The server enforces security through path validation and directory restrictions, preventing traversal attacks while enabling dynamic database creation with AI-generated filenames based on purpose descriptions. Designed for AI agents requiring persistent data storage, applications needing secure database access with multi-database support, and workflows where database operations must be restricted to specific directories for security compliance.

## Trust

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

## Facts

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

## Source

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

## 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": "liliang-cn-sqlite"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/liliang-cn-sqlite` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/liliang-cn-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