georgi-terziyski_database_mcp_server
If you are the rightful owner of georgi-terziyski_database_mcp_server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server that provides tools for connecting to and interacting with various database systems.
The Database MCP Server is a versatile tool designed to facilitate seamless interaction with multiple database systems. It supports a wide range of databases including SQLite, PostgreSQL, MySQL/MariaDB, and SQL Server, providing a unified interface for database operations. The server offers features such as schema management, query execution, and transaction support, making it a comprehensive solution for database management. Users can configure the server using environment variables, configuration files, or runtime connection details, ensuring flexibility and ease of use. Additionally, the server can be run as an MCP server for Claude or as a standalone web server, allowing integration with various LLMs.
Features
- Multi-Database Support: Connect to SQLite, PostgreSQL, MySQL/MariaDB, and SQL Server databases
- Unified Interface: Common tools for database operations across all supported database types
- Database-Specific Extensions: Where needed, specific tools for database-specific features
- Schema Management: Create, alter, and drop tables and indexes
- Query Execution: Execute raw SQL queries or use structured query tools
Tools
add_connection
Add a new database connection
test_connection
Test a database connection
list_connections
List all database connections
remove_connection
Remove a database connection
execute_query
Execute a SQL query
get_records
Get records from a table
insert_record
Insert a record into a table
update_record
Update records in a table
delete_record
Delete records from a table
list_tables
List all tables in a database
get_table_schema
Get the schema for a table
create_table
Create a new table
drop_table
Drop a table
create_index
Create an index on a table
drop_index
Drop an index
alter_table
Alter a table structure
begin_transaction
Begin a transaction
commit_transaction
Commit a transaction
rollback_transaction
Rollback a transaction
