Skip to main content
Glama
1Password-enabled MySQL MCP Server

1Password-enabled MySQL MCP Server

by chrisdail

1Password-enabled MySQL MCP Server

A Model Context Protocol (MCP) server that provides secure MySQL database access using credentials stored in 1Password. This server allows AI assistants and other MCP clients to query MySQL databases while maintaining security best practices by keeping database credentials in 1Password rather than in configuration files. By combining this into a single tool, the AI model does not ever see any passwords.

Requirements

  • Python 3.10+

  • uv (Python package manager)

  • 1Password Desktop App and 1Password CLI

  • MySQL server access

Related MCP server: MySQL MCP Server

Installation

MacOS

# Install dependencies
brew install uv 1password-cli

# Install Python dependencies
uv sync

Other Platforms

# Install uv (if not already installed)
curl -LsSf https://astral.sh/uv/install.sh | sh

# Install 1Password CLI
# Visit: https://developer.1password.com/docs/cli/get-started/

# Install Python dependencies
uv sync

Setup

1. 1Password Configuration

Ensure 1Password CLI access is enabled. Can be enabled by going to Settings -> Developer -> "Integrate with 1Password CLI". You can verify this is installed correctly by running:

op vault list

Create database items in 1Password using the database type with the following fields:

  • hostname: MySQL server hostname

  • username: MySQL username

  • password: MySQL password

  • database: Database name

  • port: MySQL port (optional, defaults to 3306)

2. Environment Configuration

Configure the following environment variables:

  • RO_DB_ENTRIES: Comma-separated list of 1Password item names for read-only databases

  • RW_DB_ENTRIES: Comma-separated list of 1Password item names for read-write databases

3. MCP Server Configuration

Add this to your MCP Server configuration file:

{
    "mcpServers": {
        "mysql": {
            "command": "[PATH_TO]/uv",
            "args": [
                "--directory",
                "[CODE_PATH]",
                "run",
                "main.py"
            ],
            "env": {
                "RO_DB_ENTRIES": "Dev Auth DB",
                "RW_DB_ENTRIES": "Dev Dashboard DB,Dev Library DB"
            }
        }
    }
}

Replace [PATH_TO]/uv with the actual path to your uv installation and [CODE_PATH] with the path to this project directory.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      Not graded
      quality
      D
      maintenance
      Enables secure interaction with MySQL databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides secure access to MySQL databases for AI assistants, enabling safe SQL queries, table information retrieval, and data insertion with built-in security protections.
      2
      MIT
    • A
      license
      A
      quality
      D
      maintenance
      Enables AI assistants to safely query MySQL databases with read-only access, featuring SQL injection protection, connection pooling, and automatic query limits for secure database exploration.
      4
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to securely connect to and manage MySQL databases with support for multiple database connections, complete CRUD operations, schema inspection, and dynamic connection management through natural language.
      19 npm
      81
      MIT