sqlitecloud/sqlitecloud-mcp-server

3.1

If you are the rightful owner of sqlitecloud-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Model Context Protocol (MCP) Server for SQLite Cloud facilitates interaction with SQLite Cloud databases using AI models, leveraging the MCP to execute queries, manage schemas, and analyze performance.

Tools

Functions exposed to the LLM to take actions

read-query

Perform SELECT queries and fetch results.

write-query

Perform INSERT, UPDATE, or DELETE operations.

create-table

Create new database tables.

list-tables

Display all tables in the database.

describe-table

Retrieve schema details for a specific table.

list-commands

List available commands and access external documentation.

execute-command

Run commands from the list-commands tool.

list-analyzer

Analyze slow queries with optional filters.

analyzer-plan-id

Gather details about query plans and indexes.

analyzer-reset

Reset query statistics for specific queries, groups, or databases.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

sqlitecloud

Claim Ownership

Verify you have write access to the repository

Version

v0.1.2

Repository

https://github.com/sqlitecloud/sqlitecloud-mcp-server

Homepage

https://sqlitecloud.io

Last publish date

2025-05-15

Last update date

2025-05-15

Server configs

via npx

bash
npx @sqlitecloud/mcp-server --connectionString <your_connection_string>

in vscode

{
  "mcp": {
    "inputs": [
     {
       "type": "promptString",
       "id": "sqlitecloud-connection-string",
       "description": "Set the SQLite Cloud Connection String",
       "password": true
     }
    ],
    "servers": {
      "sqlitecloud-mcp-server-dev": {
        "type": "stdio",
        "command": "node",
        "args": [
          "./build/index.js",
          "--connectionString",
          "${input:sqlitecloud-connection-string}"
        ]
      },
      "sqlitecloud-mcp-server": {
        "type": "stdio",
        "command": "npx",
        "args": [
          "-y",
          "@sqlitecloud/mcp-server",
          "--connectionString",
          "${input:sqlitecloud-connection-string}"
        ]
      }
    }
  }
}

in vscode

{
  "mcp": {
    "servers": {
      "sqlitecloud-mcp-server-sse": {
        "type": "sse",
        "url": "<YOUR_NODE_ADDRESS>/v1/mcp/sse",
        "headers": {
          "Authorization": "Bearer ${input:sqlitecloud-connection-string}"
        }
      }
    }
  }
}