MySQL Database
Summary
This MCP server, developed by enemyrr, provides a standardized interface for MySQL database operations. Built with TypeScript and leveraging the Model Context Protocol SDK, it offers tools for executing queries, managing database schemas, and performing CRUD operations. The implementation focuses on security, with features like prepared statements and secure password handling. It supports multiple connection methods and includes comprehensive error handling. By connecting AI models with MySQL databases, this server enables sophisticated data manipulation and retrieval scenarios, making it particularly useful for applications and AI assistants that require structured data access or need to interact with existing MySQL-based systems.
Available Actions(7)
connect_db
Connect to MySQL database using URL, workspace path, or direct credentials.
query
Execute SELECT queries with optional prepared statement parameters. Parameters: sql (string), params (array, optional)
execute
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters. Parameters: sql (string), params (array, optional)
list_tables
List all tables in the connected database.
describe_table
Get the structure of a specific table. Parameters: table (string)
create_table
Create a new table with specified fields and indexes. Parameters: table (string), fields (array), indexes (array, optional)
add_column
Add a new column to an existing table. Parameters: table (string), field (object)
커뮤니티 리뷰
아직 리뷰가 없습니다. 첫 번째 리뷰를 작성해 보세요!
대화에 참여하려면 로그인하세요
