Skip to main content
Glama
524,424 tools. Updated 2026-09-06 15:30

"Pug" matching MCP tools:

  • search_schemaA

    pg-schema-scoutA

    Find the database tables relevant to a natural language question, returning their DDL, columns, and foreign-key relationships so you can write joins without examining the entire schema.
    MIT

  • describe_tableA

    pg-schema-scoutA

    Fetch full table schema details by name, listing columns, types, primary key, and foreign keys to discover related tables in PostgreSQL.
    MIT

  • explain_queryA

    pg-schema-scoutA

    Plan a SELECT query to estimate its cost before execution, useful for large tables, missing WHERE clauses, or multiple joins. Avoids running the query, showing only the plan.
    MIT

  • run_queryA

    pg-schema-scoutA

    Execute read-only SQL queries to fetch PostgreSQL rows, blocking writes and returning result sets.
    MIT

  • decoding_statsA

    pg-logical-mcpA

    Identify replication slowness caused by large transactions spilling decode work to disk, using stats from pg_stat_replication_slots.
    GPL 3.0

Matching MCP Servers

  • Kenning PG MCP

    kenningai
    A
    license
    A
    quality
    B
    maintenance
    A secure PostgreSQL Model Context Protocol server that provides read-only database access through tools like schema listing, object inspection, query execution, and EXPLAIN analysis, with database-enforced access control via read-only transactions and a minimal role rather than SQL text parsing.
    7
    MIT

  • pg-guard-mcp

    BerkantACUN
    A
    license
    A
    quality
    C
    maintenance
    Enables read-only PostgreSQL interaction through safe query execution, query planning, table and column inspection, and privilege checks, with multi-layer defenses against write operations and transaction-control exploits.
    5
    MIT

Matching MCP Connectors

  • InfyPNG — Free Transparent PNG Clipart

    Search thousands of free transparent PNG clipart images. Free for commercial use, no attribution.

  • PubFi MCP

    Authenticated hosted Streamable HTTP MCP server for crypto data routing through PubFi capability and gateway tools.

  • diagnose_stuck_subscriptionA

    pg-logical-mcpA

    Explains the cause of a wedged logical replication subscription, identifies the conflicting row from the subscriber log, and presents two fixes: resolve the conflict or skip the offending transaction.
    GPL 3.0

  • peek_changesA

    pg-logical-mcpA

    View pending changes in a logical replication slot without consuming them. Returns up to a specified number of change records.
    GPL 3.0

  • putA

    Obsideo MCP serverA

    Store local files or inline content as objects with optional client-side encryption. Data is replicated across providers and cryptographically verified.
    MIT
    Destructive

  • package_typesA

    pkg-api-mcpA

    Retrieve the raw .d.ts type declarations for an npm package@version to get exact signatures, generics, overloads, and option-object shapes that summaries miss.
    MIT

  • inspect_subscriptionsA

    pg-logical-mcpA

    Inspect PostgreSQL logical replication subscriptions to identify apply-lag signals by reviewing subscription metadata, worker state, and LSN positions.
    GPL 3.0

  • advance_slotA

    pg-logical-mcpA

    Advance a PostgreSQL logical replication slot to a specified LSN, discarding all changes before that point. Requires exact slot name and target LSN; dry-run by default.
    GPL 3.0

  • drop_slotA

    pg-logical-mcpA

    Remove a PostgreSQL replication slot by exact name to release pinned WAL and force subscriber re-creation.
    GPL 3.0

  • inspect_walsendersA

    pg-logical-mcpA

    Check active walsender connections on the publisher, displaying per-connection state, write/flush/replay lag, and sync status to identify replication delays.
    GPL 3.0

  • subscription_errorsA

    pg-logical-mcpA

    Report apply and tablesync error counts per subscription to identify stuck subscriptions by checking apply_error_count in pg_stat_subscription_stats.
    GPL 3.0

  • list_replication_slotsA

    pg-logical-mcpA

    List replication slots and their WAL retention details, including bytes held, status, and active state, to identify slot issues on the publisher.
    GPL 3.0

  • assess_slot_riskA

    pg-logical-mcpA

    Identify which replication slot is closest to invalidation by sampling WAL generation rate and comparing to retention settings. Estimate time until disk fills if disk space is provided.
    GPL 3.0

  • skip_apply_transactionA

    pg-logical-mcpA

    Skip a stuck logical replication transaction at an explicit LSN, discarding its changes permanently. Confirm redundancy first, then pass the LSN from diagnose_stuck_subscription.
    GPL 3.0

  • pg_explain_queryA

    pg-guard-mcpA

    Get an execution plan for a read-only SELECT or WITH statement without running it, revealing query performance before actual execution.
    MIT

  • pg_check_privilegesA

    pg-guard-mcpA

    Check which database roles hold write privileges on tables. Reveals INSERT, UPDATE, DELETE, or TRUNCATE permissions so you can lock down any role missing privilege-layer defenses.
    MIT