galanblancom/db-mcp
If you are the rightful owner of db-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
A Model Context Protocol (MCP) server that provides read-only access to multiple database systems: Oracle, PostgreSQL, and SQL Server.
Tools
Functions exposed to the LLM to take actions
run-query
Executes a read-only SELECT or WITH query against the database.
get-table-info
Retrieves detailed information about a table including columns, data types, and constraints.
list-tables
Lists all tables accessible by the current user with row counts.
get-row-count
Gets the total number of rows in a table quickly without retrieving data.
list-schemas
Lists all schemas/databases accessible in the current database instance.
list-views
Lists all views accessible by the current user.
get-view-definition
Retrieves the SQL definition of a view.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client