Read-only Database MCP
Provides read-only access to MySQL/MariaDB databases with tools for listing tables, previewing table data, and executing SELECT queries.
Provides read-only access to MySQL/MariaDB databases with tools for listing tables, previewing table data, and executing SELECT queries.
Provides read-only access to PostgreSQL databases with tools for listing tables, previewing table data, and executing SELECT queries.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
Read-only Database MCP
Minimal TeamSpeak/TypeScript setup that exposes a read-only database Model Context Protocol server and a small UI for managing DB configs, toggling light/dark mode, and viewing usage history.
Prerequisites
Node 18+
A PostgreSQL or MySQL/MariaDB database user with read-only permissions
Related MCP server: postgres-mcp-server
Install
npm installRun the UI + API
Serves the config/history API and the minimalist UI at http://localhost:4000.
npm run devRun the MCP server
The MCP server reads the same saved configs from data/state.json and only exposes read-only tools.
npm run mcpTools exposed (over stdio):
list_tables— input{ db: "<configName>" }preview_table— input{ db: "<configName>", table: "table_name", limit?: number }run_select— input{ db: "<configName>", sql: "SELECT ..." }(rejects non-SELECT)
Use these tool names when connecting your model/agent to the MCP server.
How to use
Start
npm run devand open the UI. Enter DB connection details and click Save config. Set SSL mode todisable,require, orno-verify(self-signed).For MySQL/MariaDB TCP/IP, pick type “MySQL / MariaDB”.
Select the saved config in “Use config” to list tables, preview a table, or run a SELECT.
Each successful MCP/HTTP call records a history entry (DB name, tables touched, timestamp).
In your agent, connect to the MCP server via stdio and call the tools using the saved
dbname; you only need to pass the friendly name, not the credentials.
Notes
Configs and history live in
data/state.json. Delete that file to reset.The server enforces read-only mode with
SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLYand rejects non-SELECT queries.If your MCP SDK exports different helper names, adjust
src/mcp-server.tsregistration to match your SDK version.Extend
src/db.tsto add other engines (MySQL, SQLite) while keeping read-only guards.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Read-only MCP over your Excel or Airtable plus the PDFs beside it, joined as one relational dataset.
Read authorized Loam tables and supported external databases through a bounded MCP connection.
Related MCP Servers
- FlicenseNot gradedqualityCmaintenanceEnables querying and modifying PostgreSQL databases through MCP tools with read/write operations, schema inspection, and write-safety constraints that limit modifications to the mcp schema.1-
- AlicenseNot gradedqualityDmaintenanceEnables inspecting database schemas and executing read-only SQL queries on a PostgreSQL database via MCP tools.5 npmMIT
- FlicenseAqualityDmaintenanceEnables read-only exploration and querying of PostgreSQL or MySQL databases via MCP, with schema discovery, safe SQL validation, natural language to SQL conversion, and CSV export.112-
- AlicenseNot gradedqualityDmaintenanceEnables read-only SQL querying and schema inspection across MSSQL, PostgreSQL, and MySQL databases via MCP tools.ISC