mimersql avatar

Mimer Mcp

mimersql/mimer-mcp

Connects Claude to Mimer SQL databases with a clean set of schema inspection and query tools. You get list_schemas, list_table_names, and get_table_info for exploration, execute_query for parameterized SELECT statements, and a full suite for managing stored procedures including listing, viewing definitions, and execution with JSON parameters. Queries are read-only by design. Ships with Docker support and connects via stdio transport. Useful when you need Claude to work with Mimer SQL schemas directly, whether you're debugging table structures, running analytics queries, or invoking existing database procedures without writing custom integration code.

GitHub stars
3
tools
8
auth
Secret needed
transport
STDIO
env vars
12
last updated
Feb 20, 2026

Tools

8 tools

Public tool metadata for what this MCP can expose to an agent.

list_schemasList all available schemas in the database

List all available schemas in the database

No parameter schema in public metadata yet.

list_table_namesList table names within the specified schema

List table names within the specified schema

No parameter schema in public metadata yet.

get_table_infoGet detailed table schema and sample rows

Get detailed table schema and sample rows

No parameter schema in public metadata yet.

execute_queryExecute SQL query with parameter support (Only SELECT queries are allowed)

Execute SQL query with parameter support (Only SELECT queries are allowed)

No parameter schema in public metadata yet.

list_stored_proceduresList read-only stored procedures in the database

List read-only stored procedures in the database

No parameter schema in public metadata yet.

get_stored_procedure_definitionGet the definition of a stored procedure

Get the definition of a stored procedure

No parameter schema in public metadata yet.

get_stored_procedure_parametersGet the parameters of a stored procedure

Get the parameters of a stored procedure

No parameter schema in public metadata yet.

execute_stored_procedureExecute a stored procedure in the database with JSON parameters

Execute a stored procedure in the database with JSON parameters

No parameter schema in public metadata yet.

Sponsors

Configuration

DB_DSN*

Mimer SQL Database DSN

DB_USER*

Database user

DB_PASSWORD*secret

Database password

DB_HOST

Database host

DB_PORT

Database port

DB_PROTOCOL

Database protocol

DB_POOL_INITIAL_CON

Initial number of idle connections in the pool

DB_POOL_MAX_UNUSED

Maximum number of unused connections in the pool

DB_POOL_MAX_CON

Maximum number of connections allowed

DB_POOL_BLOCK

Block and wait for connection when exceeding max connections

DB_POOL_DEEP_HEALTH_CHECK

Deep health check - validates connection health before getting from pool

MCP_LOG_LEVEL

Logging level for the MCP server (DEBUG, INFO, WARNING, ERROR, CRITICAL)

Readme

Mimer MCP Server

A Model Context Protocol (MCP) server that provides Mimer SQL database connectivity to browse database schemas, execute read-only queries with parameterization support, and manage stored procedures.

Available Tools

Database Schema Tools

  • list_schemas — List all available schemas in the database
  • list_table_names — List table names within the specified schema
  • get_table_info — Get detailed table schema and sample rows

Query Execution Tools

  • execute_query — Execute SQL query with parameter support (Only SELECT queries are allowed)

Stored Procedure Tools

  • list_stored_procedures — List read-only stored procedures in the database
  • get_stored_procedure_definition — Get the definition of a stored procedure
  • get_stored_procedure_parameters — Get the parameters of a stored procedure
  • execute_stored_procedure — Execute a stored procedure in the database with JSON parameters

Getting Started

Prerequisites

  • Python 3.10 or later (with uv installed) or Docker
  • Mimer SQL 11.0 or later

Environment Configuration


View the full README on GitHub

Details

Repository
github.com/mimersql/mimer-mcp
Category
Databases
Package
mimer-mcp-server
Transport
STDIO
Auth
Required
Registry
MCP registry, active

Related Databases MCP servers

View all
1pilat avatarDataLinkpilat/mcp-datalinkMCP server for secure database access (PostgreSQL, MySQL, SQLite)3stars
2atarkowska avatarFastmcp Sqltoolsatarkowska/fastmcp-sqltoolsA MCP server provides SQL database access with support for PostgreSQL, MySQL, and SQLite.1stars
3stucchi avatarDB MCP Serverstucchi/db-mcp-serverDatabase MCP server for MySQL, PostgreSQL, MongoDB, and SQLite with SSH tunneling support.0stars
4amansingh63 avatarDBHub Analyticsamansingh63/dbhub-analyticsMCP server for Databricks, BigQuery, PostgreSQL, MySQL, SQL Server, SQLite, MariaDB0stars
5thinair avatarDataco.thinair/dataPostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.0stars
6shyamolkonwar avatarRivtorshyamolkonwar/rivtor-cliDeploy full-stack apps (frontend, backend, Postgres, Redis) from your agent and get live URLs.0stars