Spark
Sign In
MCP

Query and Manipulate SQLite Databases

MCP server that connects Claude to SQLite databases for querying, schema inspection, and write operations with parameterized queries and optional read-only

Connect
Works with sqlite
VibeBaza
Maintainer?
90
Spark score
out of 100
Updated 4 months ago
Version 1.0.0
Add to Favorites

Why it matters

Connect to SQLite databases to query data, analyze schemas, and perform database operations. Enables AI models to interact with structured data for analysis and manipulation.

Outcomes

What it gets done

01

Execute SELECT queries and retrieve results.

02

Perform INSERT, UPDATE, and DELETE operations.

03

Create new tables with specified schemas.

04

Inspect table schemas and list available tables.

Install

Add it to your toolbox

Run in your project directory:

curl -fsSL https://spark.entire.vc/get/vb-sqlite | bash

Capabilities

Tools your agent gets

read_query

Execute a SELECT query and return results from the database.

write_query

Execute an INSERT, UPDATE, or DELETE query to modify database data.

create_table

Create a new table in the database with specified schema.

list_tables

List all tables available in the database.

describe_table

Get schema information and column details for a specified table.

append_insight

Add a business insight or note to the memo.

Overview

SQLite MCP

What it does

An MCP server that provides Claude with tools to interact with SQLite databases, including read and write queries, schema inspection, table creation, and business insight memos.

How it connects

Use when you want Claude to query data, analyze database schemas, perform INSERT/UPDATE/DELETE operations, or capture business insights from SQLite databases through the Model Context Protocol.

Source README

The SQLite MCP server provides tools for interacting with SQLite databases, enabling Claude to query data, analyze schemas, and perform database operations.

Installation

Using uvx (recommended):

uvx mcp-server-sqlite --db-path /path/to/database.db

Using pip:

pip install mcp-server-sqlite

Configuration

Add to your Claude Code settings:

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "/path/to/your/database.db"
      ]
    }
  }
}

Read-Only Mode

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "/path/to/database.db",
        "--read-only"
      ]
    }
  }
}

Available Tools

read_query

Execute a SELECT query and return results.

read_query(query: string): QueryResult

write_query

Execute an INSERT, UPDATE, or DELETE query.

write_query(query: string): WriteResult

create_table

Create a new table with specified schema.

create_table(query: string): CreateResult

list_tables

List all tables in the database.

list_tables(): TableList

describe_table

Get schema information for a table.

describe_table(table_name: string): TableSchema

append_insight

Add a business insight to the memo.

append_insight(insight: string): void

Features

  • Read and write operations
  • Schema inspection
  • Safe parameterized queries
  • Transaction support
  • Read-only mode for safety
  • Business insight memos

Usage Example

Claude, connect to my database and show me all tables.
Then query the users table to find all active users
created in the last month.

Security

  • Use read-only mode for untrusted databases
  • Parameterized queries prevent SQL injection
  • File-level access permissions apply

FAQ

Common questions

Discussion

Questions & comments · 0

Sign In Sign in to leave a comment.