MCP Database Server

Example Use Cases

• 1

  List all tables in a MySQL or PostgreSQL database.

• 2

  Retrieve detailed schema information of specific database tables.

• 3

  Execute safe, read-only SQL queries within a transactional context.

Description

This MCP server implements the Model Context Protocol to allow AI models to perform safe, read-only SQL queries on relational databases such as MySQL and PostgreSQL. It provides database table structures as resources and ensures query safety through transaction management. The server supports listing database tables, retrieving table schemas, and executing read-only queries, facilitating secure and structured database interactions for AI applications.