steampipe-mcp-server

Steampipe MCP Server allows seamless interaction with PostgreSQL databases offering tools like querying and table listings. It's integrated with Steampipe, making database management straightforward.

query

Run a read-only SQL query and return results in JSON format

list_all_tables

List all tables for all schemas in the database

list_tables_in_schema

List all tables in a specific schema

get_table_schema

Get column names and data types for a specific table