Database MCP Server provides a unified interface for connecting to and interacting with multiple database systems (SQLite, PostgreSQL, MySQL/MariaDB, and SQL Server) through a consistent set of tools. It features connection management, query execution, schema manipulation, and transaction support across all supported database types. The implementation uses a modular architecture with database-specific connectors that abstract away differences between database systems, making it ideal for applications that need to work with multiple database types or for AI assistants that require database access capabilities without dealing with database-specific syntax and connection details.
まだレビューはありません. 最初のレビューを投稿しましょう!
会話に参加するにはサインインしてください
Add a new database connection. Parameters: connection_id (string), type (string), db_path (optional string for SQLite), host (optional string for PostgreSQL), port (optional integer for PostgreSQL), database (optional string for PostgreSQL), user (optional string for PostgreSQL), password (optional string for PostgreSQL)
Test a database connection. Parameters: connection_id (string)
List all database connections.
Remove a database connection. Parameters: connection_id (string)
Execute a SQL query. Parameters: connection_id (string), query (string), params (optional array of parameters for the query)
Get records from a table. Parameters: connection_id (string), table (string), conditions (optional string for WHERE clause)
Insert a record into a table. Parameters: connection_id (string), table (string), data (object representing the record to insert)
Update records in a table. Parameters: connection_id (string), table (string), data (object representing the updated values), conditions (string for WHERE clause)
Delete records from a table. Parameters: connection_id (string), table (string), conditions (string for WHERE clause)
List all tables in a database. Parameters: connection_id (string)
Get the schema for a table. Parameters: connection_id (string), table (string)
Create a new table. Parameters: connection_id (string), table (string), columns (array of objects defining the columns)
Drop a table. Parameters: connection_id (string), table (string)
Create an index on a table. Parameters: connection_id (string), table (string), index_name (string), columns (array of strings specifying the columns to index)
Drop an index from a table. Parameters: connection_id (string), index_name (string)
Alter a table structure. Parameters: connection_id (string), table (string), modifications (object defining the alterations)
Begin a transaction. Parameters: connection_id (string)
Commit a transaction. Parameters: connection_id (string)
Rollback a transaction. Parameters: connection_id (string)