steampipe-mcp-server

zen4ever/steampipe-mcp-server

3.6
Certified
databases

An MCP server interacting with PostgreSQL databases, primarily for use with Steampipe.

Tools

Functions exposed to the LLM to take actions

query

Runs a read-only SQL query against the database and returns results as JSON.

list_all_tables

Lists all available tables in all schemas in your database's search path.

list_tables_in_schema

Lists all tables within a specific schema.

get_table_schema

Retrieves column names and data types for a specific table.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources