Can it create tables?

Usually yes if the file is writable. Keep a backup before asking the agent to migrate a production SQLite file.

SQLite or Postgres page?

Local file → this page. Hosted Postgres → /use/postgres or /use/supabase.

Query a local SQLite database

Inspect and query .sqlite files from chat

SQLite jobs get lost inside Databases next to Postgres and cloud warehouses. You need a server that opens a file path, not a remote host.

Ads

Pick a server

1
modelcontextprotocol/server-sqliteRecommendedOfficial0
Official SQLite MCP — point it at a local database file.
2
hannesrudolph/sqlite-explorer-fastmcp-mcp-serverCommunity0
Community SQLite explorer with FastMCP tooling.
3
jparkerweb/mcp-sqliteCommunity0
Community SQLite MCP for simple local queries.
4
ofershap/mcp-server-sqliteCommunity0
Another community SQLite server packaging.

Official

Use the official SQLite MCP for a standard local-file setup across clients.

Community

Community explorers add richer browsing UX or FastMCP-based tooling.

Config for Cursor

One server — modelcontextprotocol/server-sqlite. Not a stack merge.

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-sqlite",
        "/path/to/database.db"
      ]
    }
  }
}

Added 15 days ago · Sep 2, 2026

FAQ

Can it create tables?: Usually yes if the file is writable. Keep a backup before asking the agent to migrate a production SQLite file.
SQLite or Postgres page?: Local file → this page. Hosted Postgres → /use/postgres or /use/supabase.

Query a local SQLite database

Pick a server

Official

Community

Config for Cursor

FAQ

Related jobs

Query a local SQLite database

Pick a server

Official

Community

Config for Cursor

FAQ

Related jobs