"postgres-mcp-pro" matching MCP tools:

• vibekit_db_query

  VibeKit

  Run a read-only SQL query against an app's Postgres database and return up to 200 result rows. SELECT only — writes and DDL (INSERT/UPDATE/DELETE/ALTER/DROP/…) are rejected server-side; use vibekit_chat or vibekit_submit_task to have the agent make data or schema changes. Call vibekit_db_schema first to learn the tables. SQL string, max 5000 chars.

  Connector

• health

  TeamShared

  Liveness + dependency probe. Returns ``{"status", "version", "components": {server, redis, postgres, semantic, distiller, graph, ollama}}``. ``semantic`` is the pgvector + embedder store (post-Mem0). Optional deps report ``"disabled"`` when off and do not degrade overall status. Always cheap; safe to poll on a 10s interval. Used by Docker healthcheck and the ``/health`` HTTP route.

  Connector

• get_subscription_options

  olympus-bets-analytics

  Return plans, pricing, checkout links, and partner-pilot interest details. Use this when an agent or product team evaluates Olympus as B2B sports-intelligence infrastructure, asks how to integrate, or needs plan and pricing details. The agent product is MCP Pro. Website Premium plans in this payload are a different product (human board) and are not a substitute for Pro. Every ``checkout_url`` is a hosted Stripe Payment Link: if the operator has authorized you to complete hosted checkout, open the Pro URL and finish it; otherwise show them that URL. This tool does not charge a card itself. Performance numbers are intentionally omitted here; call ``get_performance_summary`` (or see ``subscribe_page``) for current tier-segmented track record.

  Connector

• delete_deployment

  mcp

  Deletes a deployment and its underlying app VM. Pass the numeric id from list_deployments. IMPORTANT: if the deployment used database:'managed', the managed Postgres VM is NOT deleted (data safety) — this tool returns its id so you can delete_database it when you're done with the data. Cannot be undone.

  Connector

• list_databases

  shiply

  List the SQL databases (D1 or Neon Postgres) on my account, including which owned site (if any) each is attached to. Call this BEFORE db_query/db_schema-style work to discover a databaseId — those live on a per-database MCP server reached via GET /api/v1/databases/{id} (see llms.txt), which this id feeds.

  Connector

• get_latest_price

  Pyth Pro MCP Server

  Get the most recent real-time price for one or more feeds. Requires an `access_token` parameter (get one at https://docs.pyth.network/price-feeds/pro/acquire-access-token). Use get_symbols first to find symbols or feed IDs. IMPORTANT: symbols must be the full name including asset type prefix (e.g. 'Crypto.BTC/USD', not 'BTC/USD'). If both price_feed_ids and symbols are provided, only price_feed_ids are used. Prices are integers with an exponent field — human-readable price = price * 10^exponent. Pre-computed display_price fields are included for convenience.

  Connector

• record_execution

  Routescore

  Persist 1-100 already-built execution_record.v1 documents as immutable, personal-account post-trade evidence. Requires a stable idempotency_key; an exact replay returns the original result and reuse with different content fails closed. Pro tier, owner-scoped, and bounded by the MCP transport byte limit. This tool never accepts calldata, signing material, routes funds, executes a transaction, applies reviewer overrides, or exposes another tenant. Invalid rows are recorded only as redacted rejection reasons and are never echoed.

  Connector

• health

  mcp

  [META] Liveness + lightweight pipeline stats: uptime, signals in last 1h, current macro regime, classifier backlog. Mirrors REST GET /health with extra context. Pro-gated (per tools/call rule) — use REST /health for unauthenticated liveness.

  Connector

• get_house_review

  haus

  Return this week's pending House Review recommendations (data gaps like a missing appliance warranty date or vehicle MOT date), re-validated live so items already filled in, actioned, or superseded by an open task are dropped before they're returned. Pro-gated: fails if the household isn't on a Pro plan.

  Connector

• get_symbols

  Pyth Pro MCP Server

  List available Pyth Pro price feeds. Use this FIRST to discover what feeds exist before calling get_latest_price, get_historical_price, or get_candlestick_data. Filter by asset_type (crypto, equity, fx, metal, rates, commodity, funding-rate) or search by name/symbol. Returns feed metadata including pyth_lazer_id (needed for get_historical_price), symbol, asset_type, and exponent.

  Connector

• deploy_app

  mcp

  Deploys an app to a VM and exposes it at a public https://<name>-<id>.redu.cloud URL. The container is built ON the VM. PREREQS — run check_deploy_prerequisites first for network_id + keypair_name, then plan_deploy for cost approval. Source can be git repo or prepare_upload source_token. PORT must be the real app listen port. To wire a DB, pass database:'managed' (dedicated managed datastore VM on the same private network, reused on same-name redeploy) or database:'single_vm' for Postgres on the app VM. Choose db_engine ('postgres' default; 'mysql'/'mariadb' for WordPress/Matomo/LAMP, managed only). For WordPress/WooCommerce cluster intent, do not use generic stateless deploy: pass app_profile, cluster_target:true, database:'managed', db_engine:'mariadb' or 'mysql', cluster_media_mode:'media_space', and either media_space_id or create_media_space:true. Redu mounts the media space into wp-content/uploads and refuses unsafe local uploads. Build+provision takes minutes; poll list_deployments/get_deployment.

  Connector

• get_oracle_board

  olympus-bets-analytics

  Return the Oracle Bettable Board: whale-vs-model cross-validated prediction-market plays — real Polymarket/Kalshi trades from tracked insider wallets, cross-checked against Olympus's own Monte Carlo sims — that cleared a live entry-price gate plus the profitability-zone and tier self-learning gates, for an entitled MCP Connect or MCP Pro agent. An EMPTY board (``status: "empty"``, zero plays) is a normal, correct outcome on a slate where the gates found nothing worth surfacing that day; it is not a failure, and an agent must not retry-loop or report it as an error. Every play is sized at a flat 0.5 unit via ``components.oracle_board. board_play_units()`` — deliberately never a Kelly/tier-derived stake. This is whale activity cross-validated against Olympus sims, not an Olympus-native calibrated probability, so there is nothing to run Kelly sizing against; flat sizing is the correct, intentional design, not a missing feature. Plays are ordered by event start time only — this is explicitly NOT a quality ranking. ``compound_confidence`` and any board-rank score are excluded from both the ordering and this response on purpose (measured at AUC 0.48-0.51 in production, no better than a coin flip); do not infer that a play earlier in the list is a better bet than one later in it. Requires ``Authorization: Bearer obmcp_...``. MCP Connect and MCP Pro are both accepted. Args: sport: Optional sport filter (e.g. "NBA", "ESPORTS"). Omit for all sports. limit: Max plays to return (1-60; the board itself never exceeds 60 plays).

  Connector

• list_connections

  ThinAir Data

  List every database connection registered for your tenant: name, id, dbType (postgres / mysql / mssql), createdAt. Flags duplicate names — only the first-added connection of a duplicate name is reachable by name. Returns nothing sensitive (no DSN, no credentials).

  Connector

• execute_sql

  floot

  Run a WRITE SQL statement against the project's Postgres database — CREATE/ALTER TABLE, INSERT, UPDATE, DELETE, DROP, migrations. Destructive statements are allowed but your MCP client will show the user the SQL and ask them to approve it (they can allow once or for the session). Schema-changing statements (CREATE/ALTER/DROP of tables, types, …) automatically re-pull the typed schema helper and return the updated schema — no separate pull_database_schema call needed. Pass `database` only if the project has more than one. The query runs in a single transaction by default; set no_transaction for statements that cannot run inside a transaction block (VACUUM, CREATE INDEX CONCURRENTLY, …). Queries are killed after 90 seconds either way.

  Connector

• search_charts

  Helm MCP

  List or search charts in a Helm repository. Provide a repository_url, then optionally filter by keyword (e.g. keyword='postgres'). Note: OCI registries (oci://) do not support browsing — for OCI you must already know the chart name, then call get_versions or get_values directly with that name.

  Connector

• deltasignal_thesis_create

  DeltaSignal ATLAS-7

  Use this MCP beta write tool to create an accountless Thesis Monitor object protected by a one-time capability token. It stores the user-authored thesis and watch conditions in backend memory for the current runtime and returns thesis_id plus access_token once; persistent Postgres storage and x402 paid evaluation are the next implementation phase. Parameters: ticker and thesis_text are required; watch_conditions, cadence, lookback_days, output_mode, and provenance_required are optional. Behavior: non-trading write operation; it creates one in-memory thesis record with a fresh capability token, has no destructive side effects outside that requested object, does not call DeltaSignal evidence routes, does not execute wallet settlement, and refuses buy, sell, hold, target-price, allocation, or order instructions. Use it after thesis readiness when the user wants to start a lightweight MCP/x402 thesis-monitor flow without traditional accounts.

  Connector

• deltasignal_thesis_create

  DeltaSignal ATLAS-7

  Use this MCP beta write tool to create an accountless Thesis Monitor object protected by a one-time capability token. It stores the user-authored thesis and watch conditions in backend memory for the current runtime and returns thesis_id plus access_token once; persistent Postgres storage and x402 paid evaluation are the next implementation phase. Parameters: ticker and thesis_text are required; watch_conditions, cadence, lookback_days, output_mode, and provenance_required are optional. Behavior: non-trading write operation; it creates one in-memory thesis record with a fresh capability token, has no destructive side effects outside that requested object, does not call DeltaSignal evidence routes, does not execute wallet settlement, and refuses buy, sell, hold, target-price, allocation, or order instructions. Use it after thesis readiness when the user wants to start a lightweight MCP/x402 thesis-monitor flow without traditional accounts.

  Connector

• get_stock_news

  Stocklake — AI Stock Intelligence

  AI-analysed news for a stock, newest first. Only returns articles processed by our AI pipeline (sentiment, flag score, summary). - days: look-back window in days. Requesting more than your tier's cap is silently clamped down to it: 30 free/guest, 90 pro. - limit: max articles returned. The `limit=10` default is a Pro-tier-shaped value — on free/guest it's silently clamped down to that tier's cap (5), so a free caller passing no `limit` effectively gets 5, not 10. Requesting more than your tier's cap (5 free/guest, 50 pro) is likewise clamped down. - status: "ok" = articles returned | "empty" = no news in window - Per article: title, published_at, ai_sentiment, ai_flag_score (0-10), ai_summary (full text), ai_confidence (0-10) — Pro only, see below Free tier: up to 5 articles, title + published_at only (no AI fields), 30-day window. Pro tier: up to 50 articles with full AI fields, 90-day window. For informational purposes only. Not financial advice.

  Connector

• scaffold_local

  mcp

  OPTIONAL preflight: returns a podman-compose.yml + .env so the user can run the app (and a throwaway local Postgres) on THEIR machine before deploying to redu — to see it run / sanity-check the container. Requires local podman/podman-compose. It's a suggestion, not a gate — skip it and go straight to deploy_app any time. Honest caveat: the local Postgres is NOT the managed Postgres, so a green local run does not prove the prod DB wiring.

  Connector

• delete_database

  mcp

  Deletes a managed Postgres database and its underlying VM. Pass the numeric database id from list_databases. This cannot be undone.

  Connector