modelcontextprotocol/servers-archived

3.6

If you are the rightful owner of servers-archived 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.

SQLite MCP Server provides database interaction and business intelligence capabilities through SQLite.

Tools

Functions exposed to the LLM to take actions

read_query

Execute SELECT queries to read data from the database.

write_query

Execute INSERT, UPDATE, or DELETE queries.

create_table

Create new tables in the database.

list_tables

Get a list of all tables in the database.

describe-table

View schema information for a specific table.

append_insight

Add new business insights to the memo resource.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

modelcontextprotocol

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/modelcontextprotocol/servers-archived/tree/main/src/sqlite

GitHub Stars

134

License

MIT License

Last publish date

2025-05-28

Last update date

2025-08-16

Server configs

in claude desktop

"mcpServers": {
  "sqlite": {
    "command": "uv",
    "args": [
      "--directory",
      "parent_of_servers_repo/servers/src/sqlite",
      "run",
      "mcp-server-sqlite",
      "--db-path",
      "~/test.db"
    ]
  }
}

in vs code

{
  "mcp": {
    "inputs": [
      {
        "type": "promptString",
        "id": "db_path",
        "description": "SQLite Database Path",
        "default": "${workspaceFolder}/db.sqlite"
      }
    ],
    "servers": {
      "sqlite": {
        "command": "uvx",
        "args": [
          "mcp-server-sqlite",
          "--db-path",
          "${input:db_path}"
        ]
      }
    }
  }
}