postgresql-server-mcp
If you are the rightful owner of postgresql-server-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 henry@mcphub.com.
An MCP server designed to connect to local PostgreSQL instances for development and prototyping.
The postgreSQL-mcp-server is a Model Context Protocol (MCP) server that facilitates the connection to local PostgreSQL instances. It is primarily intended for local development and prototyping purposes. The server allows developers to interact with PostgreSQL databases through a set of tools that enable database management tasks such as listing tables, executing queries, and managing databases and tables. This server is particularly useful for developers who need to quickly set up and test database interactions in a controlled local environment. The server is built using Node.js, and it provides a straightforward setup process, making it accessible for developers familiar with JavaScript and PostgreSQL.
Features
- Connects to local PostgreSQL instances for development.
- Provides tools for database management tasks.
- Facilitates quick setup and testing of database interactions.
- Built using Node.js for easy integration.
- Supports executing arbitrary SQL queries.
Tools
list_tables
List the specified database
execute_query
check
create_database
Create new data
drop_database
Delete existing data
create_table
Create a new one with specified columns and constraints
drop_table
Delete from the database
create_index
Create a search on the specified table column
drop_index
Delete the search from the table
