MySQL Database Access MCP Server

Created By
MCP-Mirrora year ago
Mirror of
Overview

what is MySQL Database Access MCP Server?

MySQL Database Access MCP Server is a server that provides read-only access to MySQL databases, allowing users to interact with their databases securely and efficiently.

how to use MySQL Database Access MCP Server?

To use the server, install it via NPM or build it from source, configure the necessary environment variables, and add it to your MCP settings. You can then use various tools to interact with your MySQL databases.

key features of MySQL Database Access MCP Server?

  • Read-only access to databases
  • Query validation to prevent SQL injection
  • Query timeout to manage resource consumption
  • Row limit to prevent excessive data return

use cases of MySQL Database Access MCP Server?

  1. Listing available databases and tables.
  2. Describing table schemas for better understanding.
  3. Executing read-only SQL queries for data retrieval.

FAQ from MySQL Database Access MCP Server?

  • Can I modify data using this server?

No, the server only allows read-only operations to ensure data integrity.

  • How do I install the server?

You can install it globally via NPM or build it from source by cloning the repository.

  • What types of queries can I execute?

You can execute SELECT, SHOW, DESCRIBE, and EXPLAIN statements only.

Project Info
Created At
a year ago
Updated At
a year ago
Author Name
MCP-Mirror
Star
0
Language
JavaScript
License
MIT license
Category
databases

Recommend Servers

View All
Mnemom

14 hours ago
//beforeyouship — LLM Cost Modeling From Your Editor
@Indiegoing

Query realistic LLM cost models without leaving your editor. beforeyouship models the **true monthly cost** of an LLM app architecture — retries, prompt caching, batch discounts, infra overhead, and 3×/10× growth — across GPT-5.x, Claude, Gemini, DeepSeek, and more. Not a token calculator: a planning tool for the design phase, before you commit to a stack. **No API key needed to try it** — demo mode covers the six free-tier models. A Pro key from [beforeyouship.dev](https://beforeyouship.dev) unlocks the full 18-model catalog. ## What you can ask - "How much will a RAG chatbot cost at 10,000 requests/day?" - "Compare Claude Haiku vs Gemini Flash pricing for my workload" - "What's the cheapest model for a multi-step agent at scale?" - "Show me current per-token prices for Anthropic models" ## Tools ### `estimate_cost` Full cost model for an architecture at a given usage level. Returns Naive / Realistic / Worst Case monthly cost per model, 3×/10× growth scenarios, and an opinionated recommendation with reasoning. ### `get_model_prices` Current per-1M-token pricing — input, output, cached input, batch — with context windows and staleness metadata. ### `list_archetypes` Seven preset architecture patterns (simple chatbot, chatbot with history, RAG pipeline, multi-model router, coding assistant, document processor, multi-step agent) used as starting points for estimates. ## Setup **Claude Code:** ​```bash claude mcp add --transport http beforeyouship https://beforeyouship.dev/api/mcp ​``` **Cursor / other clients** — add a remote server: ​```json { "mcpServers": { "beforeyouship": { "type": "streamable-http", "url": "https://beforeyouship.dev/api/mcp" } } } ​``` Add an `Authorization: Bearer bys_...` header with a Pro key for the full catalog. ## Try it > Estimate the monthly cost of a RAG pipeline at 10,000 requests/day

13 hours ago
Docwand

13 hours ago