Sqlite MCP Server

SQLiteExplorer is an application for manipulating SQLite databases from the command line.

Local serverstdio

What is the Sqlite MCP server?

Connect Sqlite to Claude, Cursor or any other MCP client and it stops being a tab you switch to. SQLiteExplorer is an application for manipulating SQLite databases from the command line. The sqlite mcp server is what makes that connection.

What the server does

SQLiteExplorer is a command-line application designed for the manipulation of SQLite databases. With SQLiteExplorer, you can easily visualize table schemas, execute SQL queries, manage data within tables, and list tables and columns. It provides a convenient and efficient way to interact with SQLite databases directly from the command line.

  • Visualization of table schemas
  • Execution of SQL queries
  • Data management in tables
  • Listing of tables and columns
  • Export to csv files. (Since version 0.1.2)
  • Create generic SQL export file (Since version 0.1.4)

Installation

sqlite-explorer on PyPI is all you need. Most clients run it directly, so configuration is a few lines and a restart.

Available tools

The toolset is worth reading before you wire it up, because it tells you what the integration is really for:

  • Usage — Commands: data Retrieve and print data for a specific table. exec Execute a SQL statement in the database. ls-col List columns for a specific table

Worth knowing first

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

Where it fits

Among the database access options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. Sqlite's toolset — Usage — is a fair guide to whether it matches your workflow. It is maintained by Croketillo; worth a glance at recent repository activity before you build anything load-bearing on it.

SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.

Available tools

ToolWhat it does
UsageCommands: data Retrieve and print data for a specific table. exec Execute a SQL statement in the database. ls-col List columns for a specific table. ls-tab List all tables in the database. migrate-file Generates SQL file

How to install the Sqlite MCP server

{
  "mcpServers": {
    "sqlite-explorer": {
      "command": "uvx",
      "args": ["sqlite-explorer"]
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Example prompts to try

  • Use Sqlite to Usage.

Frequently asked questions

It connects Sqlite to MCP-compatible AI assistants such as Claude and Cursor, exposing 1 tool (Usage) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Sqlite directly.