home / mcp / agentmode mcp server

AgentMode MCP Server

Provides MCP access to databases and data pipelines for AI workflows via a unified data layer.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "agentmode-server": {
      "command": "uvx",
      "args": [
        "agentmode",
        "--mysql:host",
        "host",
        "--mysql:port",
        "port",
        "--mysql:username",
        "username",
        "--mysql:password",
        "password",
        "--mysql:database_name",
        "database_name",
        "--mysql:read_only",
        "true"
      ]
    }
  }
}

AgentMode MCP Server lets your coding AI access a wide range of databases and data pipelines through a single, unified MCP interface. It enables you to connect to databases, run queries, and manage data sources from your AI workflows with streamlined configuration and secure access.

How to use

Connect your MCP client to AgentMode to enable database access within your AI workflows. You provide the database connection details once, and your client can invoke queries and fetch data through the MCP channel. To start, run AgentMode in stdio mode and then configure your client to point at the running MCP server. Use the host, port, and credentials you specify to establish connections to each database you need.

Typical usage patterns include configuring a single or multiple database connections, then issuing queries from your AI prompts or tools. You can set each database connection as read-only if you are only querying data, which helps protect your data sources. As you add more databases, you’ll reuse the same MCP workflow without changing your client logic.

How to install

Prerequisites: ensure you have the MCP runtime tool installed. In this setup, you’ll use the UVX runtime to start the AgentMode MCP server.

Step 1: Install the UVX runtime (if you haven’t yet). You typically install UVX globally or ensure it’s available in your environment path.

Step 2: Start AgentMode in stdio mode. You will pass the database connection details as arguments. For a MySQL connection, run the following command, substituting host, port, username, password, and database_name with your actual values.

uvx agentmode \
--mysql:host host \
--mysql:port port \
--mysql:username username \
--mysql:password password \
--mysql:database_name database_name \
--mysql:read_only true

Supported databases

AgentMode supports a broad range of connectors. The full list includes: mysql, postgresql, bigquery, redshift, snowflake, mariadb, vitess, timescaledb, sqlserver, cockroachdb, oracle, sap_hana, clickhouse, presto, hive, trino, bigquery, redshift, snowflake, databricks, teradata, aws_athena.