Read-only Database

Provides a read-only DB context and a minimal UI for managing configs, usage history, and quick table previews.

typescript

0

GitHub Stars

typescript

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "crei03-mcp-db": {
      "command": "npm",
      "args": [
        "run",
        "mcp"
      ]
    }
  }
}

This MCP server exposes a read-only database model context, paired with a small UI to manage configurations, toggle themes, and view usage history. It connects to your database with read-only permissions and offers a secure, auditable way to run safe queries through a lightweight MCP interface.

How to use

Start by launching the user interface to configure your database connections and view history. The UI serves a config/history API and a minimalist control panel at your local address, ready for you to configure and test read-only access.

How to install

Follow these steps to set up the server locally from scratch.

npm install

Additional content

The server stores configs and usage history in a local data file. You can reset by deleting that file, which will remove saved configurations and history.

Available tools

list_tables

Exposes a list of tables for a given config name via MCP stdio input { db: "<configName>" }.

preview_table

Returns a preview of a specified table with an optional limit via MCP stdio input { db: "<configName>", table: "table_name", limit?: number }.

run_select

Executes a SELECT query against a given config via MCP stdio input { db: "<configName>", sql: "SELECT ..." } and rejects non-SELECT queries.