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.
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIAdd a new database connection. Parameters: connection_id (string), type (string), and additional connection details.
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), and optional params (array).
Get records from a table. Parameters: connection_id (string), table (string), and optional filters (object).
Insert a record into a table. Parameters: connection_id (string), table (string), and data (object).
Update records in a table. Parameters: connection_id (string), table (string), data (object), and filters (object).
Delete records from a table. Parameters: connection_id (string), table (string), and filters (object).
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), and columns (array of objects).
Drop a table. Parameters: connection_id (string), table (string).
Create an index on a table. Parameters: connection_id (string), table (string), and index details (object).
Drop an index. Parameters: connection_id (string), table (string), and index name (string).
Alter a table structure. Parameters: connection_id (string), table (string), and changes (object).
Begin a transaction. Parameters: connection_id (string).
Commit a transaction. Parameters: connection_id (string).
Rollback a transaction. Parameters: connection_id (string).
