Verify AWS Security Posture Advisor server health by checking configuration, AWS connectivity, and service availability to troubleshoot issues and confirm proper setup.
Apache 2.0
297,715 tools. Last updated 2026-07-14 08:25
"postgre" matching MCP tools:
- Discover server capabilities, supported AWS services, compliance frameworks, and intelligence engines to understand how to use the AWS Security Posture Advisor for security assessments.Apache 2.0
- Execute SQL SELECT queries to retrieve data from PostgreSQL databases. This read-only tool returns query results with rows, columns, and metadata for database analysis.MIT
- Execute write SQL statements (INSERT, UPDATE, DELETE) to modify PostgreSQL database data. Use with caution as this tool directly changes database content.MIT
- Dry-run INSERT, UPDATE, or DELETE inside a transaction, capture real results (row counts, errors, before/after data), then roll back to verify mutations safely.MIT
- Transfer database schema and data between PostgreSQL servers or databases with topological ordering. Supports dry-run to preview SQL changes.MIT
Matching MCP Servers
- AlicenseAqualityAmaintenanceProvides PostgreSQL database management and analysis via MCP, enabling schema exploration, query execution, performance monitoring, and database health checks.Last updated3618MIT
- AlicenseBqualityDmaintenanceEnables comprehensive PostgreSQL database management including index tuning, query plan analysis, health monitoring, schema-aware SQL generation, and safe SQL execution with configurable access control for both development and production environments.Last updated9MIT
- Retrieve complete table metadata including columns, constraints, indexes, size, row count, and sample rows in a single request, replacing multiple database queries.MIT
- Analyze SQL query performance by generating execution plans with cost estimates to optimize PostgreSQL database operations.MIT
- Retrieve your current PostgreSQL connection details including server name, database, schema, and access mode to verify connectivity before executing queries.MIT
- Explain PostgreSQL query execution plans to identify performance bottlenecks and missing indexes. Optionally run with analyze for real timings.MIT
- Identify database health problems by running checks on indexes, connections, vacuum, sequences, replication, buffer cache, and constraints.MIT
- Explains SQL query execution plans with cost estimates. Optionally runs query for real statistics or simulates hypothetical indexes to compare performance.MIT
- Discover all configured PostgreSQL servers and their connection status. Use this first to get available server names before proceeding with other actions.MIT
- List all schemas in the connected PostgreSQL database. Optionally include system schemas or use one-time server/database/schema overrides.MIT
- Execute SQL files for database migrations, schema changes, or data imports. Supports atomic transactions, validation preview, and pattern stripping for compatibility.MIT
- Preview a SQL file to see statement counts, type breakdown, and danger warnings without executing. Understand migration impact before running.MIT
- Test SQL migrations safely by executing all statements in a transaction, capturing real results and errors, then rolling back to prevent changes.MIT
- Export database schema (DDL) and data to a SQL file for migration scripts or backups. Supports objects, table data, schema dumps, and query results.MIT
- Converts high-level schema change intents (add column, foreign key, index, etc.) into multi-step zero-downtime DDL recipes for safe table alterations.MIT
- Cancel or terminate a PostgreSQL backend session by PID. Use soft cancel to interrupt a query or hard terminate to kill the entire backend.MIT