Skip to main content
MCP Server
SQLite avatar

SQLite

by @modelcontextprotocol

Official Install with VS Code GitHub

Database interaction and business intelligence capabilities

Share
sqlitedatabasesqllocalfile
950 stars TypeScript MIT Updated: 2025-04-18

Send to Your Agent

Copy this prompt and paste it into Claude, Cursor, or any MCP client to install instantly.

Install the SQLite MCP server for me.

Server: SQLite
Description: Database interaction and business intelligence capabilities
Install command: npx -y @modelcontextprotocol/server-sqlite /path/to/database.db

GitHub: https://github.com/modelcontextprotocol/servers-archived/tree/main/src/sqlite

Please install this MCP server and confirm when ready.

Paste into any AI agent with MCP support — works with Claude Desktop, Cursor, Cline, and more.

Quick Install

Config file: ~/Library/Application Support/Claude/claude_desktop_config.json

  1. Open Claude Desktop app
  2. Go to Settings → Developer → Edit Config
  3. Paste the config below into the file
  4. Restart Claude Desktop
{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-sqlite",
        "/path/to/database.db"
      ]
    }
  }
}

Add this to your ~/Library/Application Support/Claude/claude_desktop_config.json

Installation Methods

npx Run directly with npx
npx -y @modelcontextprotocol/server-sqlite /path/to/database.db

Tools (5)

query

Execute a SQL query against the SQLite database

get_schema

Get the database schema including tables and columns

create_table

Create a new table in the database

insert_data

Insert data into a table

update_data

Update existing data in a table

Compatibility

Claude Desktop
Cursor
Cline
VS Code
Devin (formerly Windsurf)

About

A Model Context Protocol server that provides access to SQLite databases. This server enables LLMs to interact with local SQLite files for data storage, querying, and analysis.

Key Features

  • Local file-based — No server setup required, works with .db files
  • Full CRUD operations — Create, read, update, delete data
  • Schema management — Create tables and inspect structure
  • Lightweight — Perfect for local development and small projects

Use Cases

  • Local data analysis — "Analyze this SQLite database of sales data"
  • Prototype development — "Create a database schema for a todo app"
  • Data migration — "Export data from this SQLite file to CSV"
  • Testing — "Set up test data for my application"
  • Personal projects — "Build a simple note-taking app with SQLite"

Related Resources

PostgreSQL

MCP Server

Read-only database access with schema inspection

Database Migration Planner

Prompt

Plan zero-downtime database migrations with rollback strategies and data integrity checks.

Database Optimization Expert

Skill

Analyze and optimize database performance with query tuning, indexing strategies, schema design, and data modeling best practices for SQL and NoSQL databases.

Artificial Intelligence

Glossary

The broad field of creating machines that can perform tasks requiring human-like intelligence, such as reasoning, learning, and perception.

Redis

MCP Server

Interact with Redis key-value stores

Compare LLM Pricing

This server works with Claude, GPT-4o, and other models. Compare API costs side-by-side to find the cheapest option for your workflow.

Browse Pricing Compare Models Cost Calculator