steampipe-mcp-server
If you are the rightful owner of steampipe-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
An MCP server interacting with PostgreSQL databases, primarily for use with Steampipe.
The Steampipe MCP Server is designed to facilitate interaction with PostgreSQL databases, specifically tailored for use with Steampipe. Steampipe organizes data into schemas per connection, creating a search path that includes all schemas, though the public schema is typically empty. This server is particularly useful when working with Steampipe plugins for AWS, GCP, and other cloud services, which can have numerous tables. To efficiently retrieve data, users are encouraged to specify schemas, such as 'aws_all', to limit the number of tables retrieved. The server supports various tools for querying and managing database schemas, making it a versatile solution for database interaction within the Steampipe ecosystem.
Features
- Integration with PostgreSQL databases for Steampipe.
- Schema-based organization for efficient data retrieval.
- Support for Steampipe plugins for AWS, GCP, and other clouds.
- Tools for querying and managing database schemas.
- Environment variable configuration for database connections.
Tools
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.
