MySQL

• FastMCP

• SSE Server-Sent Events

• MySQL

• /

• SQL - - SQL - - WHERE -

API

• `mysql_query`: SQL

• `mysql_show_tables`:

• `mysql_show_columns`:

• `mysql_describe_table`:

• `mysql_show_create_table`:

• `mysql_show_databases`:

• `mysql_show_variables`: MySQL

• `mysql_show_status`: MySQL

• `mysql_show_indexes`:

• `mysql_show_table_status`:

• `mysql_show_foreign_keys`:

• `mysql_paginate_results`:

• Python 3.6+

• MySQL

• - mysql-connector-python - python-dotenv - mcp (FastMCP )

1. - `.env.example` `.env` - `.env`

• `HOST`: 127.0.0.1

• `PORT`: 3000

• `MYSQL_HOST`: MySQL

• `MYSQL_PORT`: MySQL

• `MYSQL_USER`: MySQL

• `MYSQL_PASSWORD`: MySQL

• `MYSQL_DATABASE`: MySQL

SQL

• `ENV_TYPE`: development/production

• `ALLOWED_RISK_LEVELS`: LOW/MEDIUM/HIGH/CRITICAL

• `BLOCKED_PATTERNS`: SQL

• `ENABLE_QUERY_CHECK`: SQL true/false

• `ALLOW_SENSITIVE_INFO`: true/false

• `SENSITIVE_INFO_FIELDS`:

• LOW: SELECT SHOW, DESCRIBE

• MEDIUM: INSERT WHERE UPDATE/DELETE

• HIGH: CREATE/ALTER WHERE UPDATE

• CRITICAL: DROP/TRUNCATE WHERE DELETE

• - - -

• - LOW - - -

• password auth credential key secret private

• ssl tls cipher certificate

• host path directory

• INSERT/UPDATE/DELETE

DELETE

• DELETE WHERE

• WHERE DELETE CRITICAL

• ALLOWED_RISK_LEVELS CRITICAL

• server.py load_dotenv()

• " "

• ALLOWED_RISK_LEVELS

• WHERE UPDATE DELETE WHERE 1=1

• ALLOW_SENSITIVE_INFO=true

• MySQL

• SQL