How to Install SQLite MCP Server in Gemini CLI

SQLite database queries, analysis, and memo storage for local AI workflows

What SQLite MCP Server does

A lightweight but powerful MCP server for SQLite databases. Query local databases, inspect schemas, run aggregations, and store persistent memos — all through natural language with your AI agent. Features: - Full read/write access to SQLite databases - Schema inspection and table listing - Natural language query execution - Built-in memo/note storage system - Business insight generation from query results - No external services required — runs entirely locally - Perfect for local analytics, prototyping, and AI-assisted data exploration Unlike cloud database servers, SQLite MCP requires no credentials or network access — ideal for local development, quick analysis tasks, or building offline-capable AI workflows. Installation uses Python's uvx package runner (part of uv, the fast Python package manager).

sqlite

sql

database

local

analytics

Installation steps

1Copy the config below
2Open ~/.gemini/settings.json
3Paste inside "mcpServers": {}
4Restart Gemini CLI

Configuration

File location: ~/.gemini/settings.json

settings.jsonjson

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

Full server details GitHub Open Config Editor

Install in other clients

🤖Claude Desktop 💻Claude Code ⌨️Cursor 🏄Windsurf ✨OpenAI

For maintainers

If you maintain SQLite MCP Server, add this badge to your README to show it's verified on CuratedMCP:

[![CuratedMCP Verified](https://curatedmcp.com/api/badge/sqlite-mcp-server)](https://curatedmcp.com/marketplace/sqlite-mcp-server)

Related servers

PostgreSQL MCP

Natural language SQL queries on your PostgreSQL databases

Free

Notion MCP Server

Read, write, and search your Notion workspace — databases, pages, and knowledge base

Free

Supabase MCP Server

Official Supabase integration — manage tables, run queries, handle auth, and deploy edge functions

Free