Database Connector
Summary
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.
Available Actions(19)
add_connection
Add a new database connection. Parameters: connection_id (string), type (string), additional connection details (variable)
test_connection
Test a database connection. Parameters: connection_id (string)
list_connections
List all database connections.
remove_connection
Remove a database connection. Parameters: connection_id (string)
execute_query
Execute a SQL query. Parameters: connection_id (string), query (string), params (optional array)
get_records
Get records from a table. Parameters: connection_id (string), table (string), filters (optional object)
insert_record
Insert a record into a table. Parameters: connection_id (string), table (string), data (object)
update_record
Update records in a table. Parameters: connection_id (string), table (string), data (object), filters (optional object)
delete_record
Delete records from a table. Parameters: connection_id (string), table (string), filters (object)
list_tables
List all tables in a database. Parameters: connection_id (string)
get_table_schema
Get the schema for a table. Parameters: connection_id (string), table (string)
create_table
Create a new table. Parameters: connection_id (string), table (string), columns (array of objects)
drop_table
Drop a table. Parameters: connection_id (string), table (string)
create_index
Create an index on a table. Parameters: connection_id (string), table (string), index_details (object)
drop_index
Drop an index. Parameters: connection_id (string), table (string), index_name (string)
alter_table
Alter a table structure. Parameters: connection_id (string), table (string), changes (object)
begin_transaction
Begin a transaction. Parameters: connection_id (string)
commit_transaction
Commit a transaction. Parameters: connection_id (string)
rollback_transaction
Rollback a transaction. Parameters: connection_id (string)
Community Reviews
No reviews yet. Be the first to review!
Sign in to join the conversation
