MCP Directory

How to add MCP SQLite Server to Windsurf

Comprehensive SQLite database interaction over MCP: CRUD, introspection, and custom SQL queries. Paste the config into ~/.codeium/windsurf/mcp_config.json and restart Windsurf.

Last updated June 14, 2026 · 110★ · stdio · no auth

Windsurf config for MCP SQLite Server

npx -y mcp-sqlite <path-to-your-sqlite-database.db>
{
  "mcpServers": {
    "mcp-sqlite-server": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite",
        "<path-to-your-sqlite-database.db>"
      ]
    }
  }
}

Setup steps

  1. 1Open Windsurf → Cascade → the hammer/MCP icon → Configure (or edit ~/.codeium/windsurf/mcp_config.json).
  2. 2Paste the MCP SQLite Server config below.
  3. 3Fill in placeholder secrets, then save.
  4. 4Click Refresh in the MCP panel.
  5. 5MCP SQLite Server's tools become available to Cascade.

Before you start

  • Node.js (npx) available on the host
  • A path to an existing SQLite database file

What MCP SQLite Server can do in Windsurf

db_info

Get detailed information about the connected database.

list_tables

List all tables in the database.

get_table_schema

Get detailed information about a table's schema. Parameters: tableName (string).

create_record

Insert a new record into a table. Parameters: table (string), data (object of key-value pairs).

read_records

Query records from a table with optional filtering. Parameters: table (string), conditions (object, optional), limit (number, optional), offset (number, optional).

update_records

Update records in a table that match specified conditions. Parameters: table (string), data (object), conditions (object).

delete_records

Delete records from a table that match specified conditions. Parameters: table (string), conditions (object).

query

Execute a custom SQL query against the connected SQLite database. Parameters: sql (string), values (array, optional) of parameter values.

Security

The server connects to whatever SQLite database file is passed as an argument and exposes full read/write access, including a `query` tool that executes arbitrary SQL. Point it only at databases you are willing to expose to the AI client.

MCP SQLite Server + Windsurf FAQ

Where is the Windsurf config file?

Windsurf reads MCP servers from ~/.codeium/windsurf/mcp_config.json. Paste the MCP SQLite Server config there under the "mcpServers" key and restart the client.

Is MCP SQLite Server safe to use with Windsurf?

The server connects to whatever SQLite database file is passed as an argument and exposes full read/write access, including a `query` tool that executes arbitrary SQL. Point it only at databases you are willing to expose to the AI client.

How do I tell the server which database to use?

Pass the path to your SQLite database file as an argument, e.g. `npx -y mcp-sqlite <path-to-your-sqlite-database.db>`. The database path is required.

Which clients are supported?

Any MCP client that supports stdio servers. The README provides configuration examples for Cursor (mcpServers block) and VSCode (servers block).

Can it run arbitrary SQL?

Yes. The `query` tool executes custom SQL against the connected database and supports parameterized values via an optional `values` array.

View repo Full MCP SQLite Server page