Database MCP Server

List all database roles

Create a database role

Create a database user (role with LOGIN)

Alter a role

Drop a role

Grant a role to another role (membership)

Revoke role membership

Grant schema privileges (USAGE, CREATE) to a role

Revoke schema privileges from a role

Grant table privileges to a role

Revoke table privileges from a role

Grant privileges on all tables in a schema to a role

Revoke privileges on all tables in a schema from a role

List all grants for a role (table privileges)

Execute a SELECT query

Insert rows into a table

Update rows in a table

Delete rows from a table

Execute arbitrary SQL (DDL/DML). Use for advanced operations. Prefer specific tools when possible.

List all configured databases

Get details of a specific database

List installed extensions

Install an extension

Remove an extension

List functions

Create a function

Drop a function

List indexes

Create an index

Drop an index

List migrations: applied (in DB) and pending (files not yet applied). Use to sync database.

Apply a single migration by filename

Apply all pending migrations to sync the database. Runs migrations in order.

List all database schemas

Create a new schema

Get schema details

Rename a schema

Drop a schema

List sequences

Create a sequence

Drop a sequence

List tables in a schema

Create a new table

Get table details (columns, PK, FK)

Alter table (add/drop columns, rename)

Drop a table

List triggers

Create a trigger

Drop a trigger

List views

Create a view

Get view definition

Drop a view