tokenlite-mysql-mcp

Description

TokenLite MySQL MCP is an advanced Model Context Protocol server built from the ground up to integrate MySQL databases with Large Language Models (LLMs) in the most secure and efficient way possible. Unlike standard direct database connections, TokenLite is designed to mitigate the most common issues faced by AI agents: schema hallucinations, context window bloat, and dangerous, resource-heavy operations. Instead of exposing the raw database, it acts as an intelligent middleware that guides the LLM to extract exactly what it needs without overwhelming its context window. Key Features: - 🛡️ Safe Query Execution (AST Parsing): Intercepts and parses SQL queries using an Abstract Syntax Tree (AST), automatically injecting limits to prevent massive data dumps and blocking unindexed full table scans. - 🧠 Contextual Schema Search: Instead of running token-heavy SHOW TABLES commands, it uses a search_schema tool to provide the LLM with a compressed, heuristic-based graph containing the requested table's DDL and its implicitly related tables. - 📊 Analytical Query Templates: Prevents agents from hallucinating business metrics. It provides pre-approved, vetted SQL templates for complex calculations (LTV, Revenue, Active Users, etc.) ready to be executed safely. - 🔍 Optimizer Analysis (Explain Query): Provides native tools for the agent to check the execution plan (EXPLAIN) of its own queries before running them, encouraging self-correction and performance optimization. - 🔒 Read-Only / Safe Mode: A security-first architecture, ideal for connecting AI agents to production or analytical environments without the risk of unwanted mutations.

Community Metrics

Categories

• mcp

Tags

• mcp
• smithery

Capabilities

• Local MCP server

Information