Connect Claude Code to PostgreSQL

Execute a SELECT query and return results as JSON

Execute an INSERT, UPDATE, DELETE, or other non-SELECT statement

Execute a statement with multiple parameter sets (batch operations)

Execute query with cursor for large result sets

Bulk import data to a table using COPY

Bulk export data from a table using COPY

List all tables in a schema

Get column metadata for a table

Get detailed information about a table including constraints and indexes

Create a new table

Drop a table

Truncate a table (remove all rows)

List all schemas in the database

Create a new schema

Drop a schema

List all databases in the PostgreSQL server

List all indexes in a schema

Create an index on a table

Drop an index

List all views in a schema

Create a view

Drop a view

List all sequences in a schema

Get the next value from a sequence (nextval)

Get the current value from a sequence (currval)

Set the current value of a sequence (setval)

List all functions in a schema

Call a PostgreSQL function

List all constraints for a table

List all triggers in a schema

List all installed extensions

Create/install an extension

List all database users

List all database roles

Explain a query's execution plan

Vacuum a table to reclaim storage and update statistics

Analyze a table to update statistics

Begin a new transaction

Commit the current transaction

Rollback the current transaction