postgresql-server-mcp

The project is an MCP server that facilitates the connection and management of local PostgreSQL instances, making it useful for development and prototyping. It provides a range of tools for database and table management, as well as query execution.

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