"postgres-mcp-pro" matching MCP tools:

• get_latest_priceA

  Pyth Pro MCP ServerA

  Get the most recent real-time price for one or more feeds. Requires the user's own Pyth Pro access token. If the user configured it in their MCP client, omit `access_token`; otherwise pass it as `access_token`, and if the tool reports it missing, ask the user for it. Symbols can be full names from get_symbols (e.g. 'Crypto.BTC/USD', 'Equity.US.AAPL/USD') or bare pairs like 'BTC/USD'. A bare pair resolves to the live spot feed when there is one, otherwise to the only remaining live match; `resolved_symbols` in the response shows what each input resolved to, and an ambiguous input returns an error listing the candidates. If both price_feed_ids and symbols are provided, only price_feed_ids are used. Requested feeds that return no price are listed in `missing_feed_ids` (e.g. beta or coming_soon feeds, or a channel faster than the feed's min_channel). Prices are integers with an exponent field: human-readable price = price * 10^exponent. Pre-computed display_* fields (display_price, display_bid, display_ask, display_confidence, display_ema_price, display_ema_confidence, display_funding_rate) apply the exponent for you. Price tools: get_latest_price for now, get_historical_price for one past instant, get_price_range for every update within up to 60 seconds, get_candlestick_data for OHLC bars over longer periods.

  ConnectorNo auth

• delete_deploymentA

  mcpA

  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

  Destructive

  No auth

• list_databasesA

  shiplyA

  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.

  ConnectorNo auth

• query_databaseA

  flootA

  Run a READ-ONLY SQL query against the project's Postgres database (SELECT, EXPLAIN, etc.) — the Floot-managed database, or an external Postgres the user connected to the project. Writes are rejected — use execute_sql for those. Returns JSON: `{rows, rowCount, command, truncated?}` (or `{results: [...]}` for multi-statement queries). Pass `database` only if the project has more than one.

  ConnectorOAuth

• get_player_propsA

  olympus-bets-analyticsA

  Return the live player-props board for NFL, MLB or WNBA (MCP Connect or Pro). Requires ``Authorization: Bearer obmcp_...`` (MCP Connect — included with website Premium — or MCP Pro). Free and anonymous callers are denied. Each prop row carries: player, team, game, kickoff (America/New_York), market, line, model projection, model over/under probability, the stored best price and book (plus other books where the odds file stores them), edge_pct, the model's pick side, confidence tier and units where the lane produces them, whether it is on the lane's premium board, and ``lane_status`` — the factual verdict of that lane's promotion gate (e.g. NFL ``research_board``, WNBA ``promoted_live``, MLB per market). lane_status is information, not a filter: every row is returned. Prices are exactly as stored by the odds pipeline; a missing price is ``null`` (never a placeholder). MLB rows come from the daily MLB props export: the MLB ledger stores no pick side for player props, so ``pick_side`` is null and ``edge_pct`` is the stored OVER-side edge (``edge_side: "over"``). Args: league: ``nfl``, ``mlb`` or ``wnba`` (required). date: ``YYYY-MM-DD`` slate date in the live window — yesterday through 7 days ahead (America/New_York); defaults to today. Earlier dates are resolved history: use ``get_player_prop_history`` (MCP Pro). game: Optional matchup/team filter (e.g. ``"NE@JAX"``, ``"JAX"``). player: Optional player-name filter (substring, accent-insensitive). market: Optional market filter (e.g. ``rush_yds``, ``points``, ``pitcher_ks``). limit: Max rows (1-200, default 100), sorted by edge_pct descending.

  ConnectorNo auth

• execute_sqlA

  flootA

  Run a WRITE SQL statement against the project's Postgres database (the Floot-managed one, or an external Postgres the user connected) — 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

  Destructive

  OAuth

• rayana_ai_plansA

  Rayana AIA

  What Rayana AI costs and what each tier unlocks. No API key needed — call this first if a research tool refused you for want of one. API and MCP access start at the Pro tier. Prices are USD; annual billing is ten months' price for twelve. Use ``rayana_ai_start_checkout`` to turn a choice here into a link your principal can open.

  ConnectorNo auth

• generate_assetA

  IconScout MCPA

  Generate NEW icon / illustration / 3D illustration / image artwork with IconScout AI — iconscout.com's AI suite. Use it when the user asks to generate / create / make a custom asset, or when search_assets has no good match and the user wants one made. Prefer search_assets for ready-made assets. Set `asset` to the type they want. WHICH TYPE — if the user names it ("Generate a home icon", "3D illustration of a home"), pass `asset` so the picker skips the type step. If they don't ("Generate a home asset"), OMIT `asset`: the picker first asks which type they want. THE USER PICKS, EVERY TIME — for a generation request, call this tool with just the `prompt` (and `asset`): it opens a model → style picker (free) where the user picks the model (with its credits) and style (when the generator has styles), and the picker generates by itself — do NOT pass `model` / `style` yourself. Pass them ONLY when no picker can be shown (no widget): then ask in chat first — MODEL as "<name> — <credits> credits" (keep the RECOMMENDED mark), then STYLE (only if the generator lists styles) — never choose for them, and call with their `model` (and `style`, only when the generator has styles), mentioning the total cost (credits × variations). GENERATORS: AI Icon Generator — asset `icon`, default model `flux-2-pro`, default style `icon` Models: - Flux.2 Pro (`flux-2-pro`) — 10 credits/image · Production Quality - Flux.2 Klein (`flux-2-klein`) — 5 credits/image · Fast Generation - GPT 2 [RECOMMENDED] (`gpt-2`) — 15 credits/image · Text Support, High Resolution - Recraft 20b (`recraft-20b-svg`) — 10 credits/image · SVG Vector, Graphic Design · styles: icon, icon_outline, icon_glyph, icon_colored_outline, icon_flat, icon_broken_line, icon_gradient, icon_doodle - Nano Banana 2 (`nano-banana-2`) — 20 credits/image - Seedream 5 (`seedream-5`) — 10 credits/image · Style Consistency - Grok (`grok`) — 10 credits/image · Fast Generation - Qwen (`qwen`) — 10 credits/image - Nano Banana Pro (`nano-banana-pro`) — 25 credits/image - GPT 2.5 Pro (`gpt-2-5-pro`) — 15 credits/image · Precision - Krea 2 Turbo (`krea-2-turbo`) — 5 credits/image · Fast Generation, Lowest Cost - Recraft Vector (`recraft-vector`) — 20 credits/image · Native SVG, Editable Paths - Recraft Vector Pro (`recraft-vector-pro`) — 50 credits/image · Native SVG, Highest Detail Styles: icon (Default), icon_outline (Outline), icon_glyph (Glyph), icon_colored_outline (Colored line), icon_flat (Flat), icon_broken_line (Broken line), icon_gradient (Gradients), icon_doodle (Doodle), icon_isometric_3d (3D Isometric), icon_3d (3D Style), icon_3d_glass (3D Glass). A model offers icon, icon_outline, icon_glyph, icon_colored_outline, icon_flat, icon_isometric_3d, icon_3d_glass, icon_3d unless it lists its own. AI Illustration Generator — asset `illustration`, default model `flux-2-pro` Models: - Flux.2 Pro (`flux-2-pro`) — 10 credits/image · Production Quality - Flux.2 Max (`flux-2-max`) — 15 credits/image · Premium Quality - GPT 2 (`gpt-2`) — 15 credits/image · Text Support, High Resolution - Recraft 20b (`recraft-20b-svg`) — 10 credits/image · SVG Vector, Graphic Design - Recraft V4 (`recraft-v4`) — 10 credits/image · Design Quality, Graphic Design - Recraft V4 Pro (`recraft-v4-pro`) — 35 credits/image · Creativity, High Resolution - Nano Banana 2 (`nano-banana-2`) — 20 credits/image - Seedream 5 (`seedream-5`) — 10 credits/image · Style Consistency - Grok (`grok`) — 10 credits/image · Fast Generation - Nano Banana Pro (`nano-banana-pro`) — 25 credits/image - GPT 2.5 Pro (`gpt-2-5-pro`) — 15 credits/image · Precision - Krea 2 Turbo (`krea-2-turbo`) — 5 credits/image · Fast Generation, Lowest Cost - Recraft Vector (`recraft-vector`) — 20 credits/image · Native SVG, Editable Paths - Recraft Vector Pro (`recraft-vector-pro`) — 50 credits/image · Native SVG, Highest Detail No styles — pick the model only; never pass `style`. AI 3D Generator — asset `3d`, default model `flux-2-pro`, default style `default` Models: - Flux.2 Pro (`flux-2-pro`) — 10 credits/image · Production Quality - GPT 2 [RECOMMENDED] (`gpt-2`) — 15 credits/image · Text Support, High Resolution - Recraft V4 (`recraft-v4`) — 10 credits/image · Design Quality, Graphic Design - Nano Banana 2 (`nano-banana-2`) — 20 credits/image - Seedream 5 (`seedream-5`) — 10 credits/image - Grok (`grok`) — 10 credits/image · Fast Generation - Nano Banana Pro (`nano-banana-pro`) — 25 credits/image Styles: default (3D Illustration), avatar (Avatar), character (Character). A model offers default, avatar, character unless it lists its own. AI Image Generator — asset `photo`, default model `flux-2-pro` Models: - Flux.2 Pro (`flux-2-pro`) — 10 credits/image · Production Quality - Recraft V4 (`recraft-v4`) — 10 credits/image · Design Quality, Graphic Design - Nano Banana 2 (`nano-banana-2`) — 20 credits/image - Seedream 5 (`seedream-5`) — 10 credits/image · Style Consistency - Qwen (`qwen`) — 10 credits/image - Grok (`grok`) — 10 credits/image · Fast Generation - Nano Banana Pro (`nano-banana-pro`) — 25 credits/image No styles — pick the model only; never pass `style`. COSTS AI CREDITS — free accounts get a few free generations. On a credit / free-trial message, relay it — do NOT retry. Returns right away: the images show in the interactive grid (skeletons first) as they finish, and the user downloads them from there. Generation takes a few seconds to a few minutes — never re-generate while they run.

  ConnectorOAuth

• chat_knowledgeA

  AlgoVault — Crypto Quant Trade CallsA

  Returns a synthesized natural-language answer with citations, grounded in the AlgoVault knowledge bundle (every MCP tool description, response shape, integration tutorial, and code example). Use when you need an explanation, code pattern, or how-to; for raw ranked snippets without LLM synthesis use search_knowledge (faster, no quota cost). Read-only: calls an LLM, no other side effects. Quota: Free 10/month, Starter 50, Pro 200, Enterprise 2000.

  ConnectorNo auth

• colony_search_group_messagesA

  mcp-serverA

  Full-text search messages in a specific group. Uses Postgres ``plainto_tsquery`` with the 'simple' config (same as the global ``/messages/search``). Scoped to non-soft-deleted rows. Caller must be a member. Hits are in ``items``; ``results`` is a DEPRECATED duplicate of the same list. ``count`` is how many hits this response holds; ``has_more`` is true when more match than ``limit`` allowed.

  ConnectorNo auth

• deploy_appA

  mcpA

  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.

  ConnectorNo auth

• healthA

  TeamSharedC

  Liveness + dependency probe. Returns ``{"status", "version", "components": {server, redis, postgres, semantic, distiller, graph, ollama}}``. ``semantic`` is the pgvector + embedder store. 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.

  ConnectorNo auth

• search_chartsA

  Helm MCPA

  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.

  ConnectorNo auth

• scaffold_localA

  mcpA

  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.

  ConnectorNo auth

• delete_databaseA

  mcpA

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

  Connector

  Destructive

  No auth

• find_professionalA

  mcpA

  Find EnMente professionals matching a natural-language query in Spanish (e.g. "psiquiatra TDAH adultos", "psicóloga pareja online", "duelo adulto mayor"). Uses Postgres FTS over name, role, specialties, tagline, category, and bio. Returns ranked matches with relevance score. Each match includes a `pricing` object (currency CLP, services with price and duration) when fresh pricing data exists — `pricing.available` is false with no invented price otherwise.

  ConnectorNo auth

• data_queryA

  termalin-webA

  Run a database query on one of your servers — passwordless. It executes the engine's own client on the host over Termalin's keyless tunnel, using the database's local trust (Postgres peer auth via `sudo -u postgres`, MySQL/MariaDB unix-socket via `sudo mysql`, redis-cli, mongosh, sqlite3) — so no database password is needed or stored anywhere. Read-only by default: only SELECT/SHOW-style statements run unless allowWrites is set (full-access keys only). SQL engines return CSV/TSV with a header. For MongoDB pass a shell expression, e.g. db.products.find({}).limit(20).toArray().

  Connector

  Destructive

  No auth

• generate_imageA

  Nano Studio ProA

  Generates an AI image. COSTS CREDITS (call get_pricing: generate_* for Nano Banana 2.1, generate_pro_* for Nano Banana Pro, generate_gpt_* for GPT Image 2.5). Returns the image inline plus id and credits_remaining. Attach references with reference_asset_ids (up to 14). @slug in the prompt or entity_ids attach a saved entity's sheet (list_entities). Pick `model` for the job: Nano Banana 2.1 (default) for light, texture, mood and speed; Nano Banana Pro when structure and proportion must hold exactly; GPT 2.5 Flare for text you can actually read (labels, packaging, signs); GPT 2.5 Sunburst for the same with more care over references, slower. GPT tops out at 2K.

  ConnectorAPI key

• billing_machine_payA

  CorroborateMeA

  Return prepaid Pro purchase instructions. This tool does not charge a card, grant Pro, or return an aa_ secret. MCP requires a company API key (aa_...) or an MCP OAuth access token; a bootstrap token is not accepted on this call. Optional sku defaults to pro_prepaid_30d. On success, returns sku, amount (the live price), currency, periodDays, mppConfigured, action (POST /api/billing/machine-pay), agentSkus, and instructions. If MPP is not configured and local billing bypass is off, returns an error with code mpp_not_configured and does not grant Pro. An unknown sku returns invalid_sku. The REST POST /api/billing/machine-pay is what charges or grants: with MPP enabled it starts a prepaid charge and, only when the caller used a bootstrap token and the company has no API key yet, returns secret (aa_..., shown once) after settlement. With local billing bypass and MPP off, that REST call grants Pro for the SKU period with no Stripe charge and may return the same secret on the bootstrap path. Use billing_checkout for a human Stripe Checkout session.

  ConnectorAPI key

• list_categoriesA

  New Site RadarA

  Category slugs on the current board (with site counts), plus the valid values for search_sites filters (type, visits, mom, payment). Requires an API key (Authorization: Bearer nsr_… or x-api-key: nsr_…): free key from https://newsiteradar.com/mcp (20 calls a day, Pro-only fields hidden) or Pro.

  ConnectorNo auth

• calibration.trainA

  Nimbus BCIA

  Train the subject's own classifier from a COMPLETED calibration session (NON-BLOCKING). Fetches the recorded upload, wires it into a train pipeline as a custom_data source, and starts the run. Requires a Pro plan (custom_data training is freemium-gated). The calibrate→train handoff requires a Postgres-backed backend (hosted or local dev); a desktop-local session completes and records, but its upload can't be resolved by MCP train today.

  ConnectorNo auth