"PostgreSQL MCP (Multi-Version Concurrency Control or specific usage)" matching MCP tools:

• get_scheduleA

  TessryxA

  Get a single schedule by slug or id, including its cron status (last_published_version, next_run_at, last_run_id) and the definition body of its current version (published if any, else latest). Use get_schedule_version to read a specific older version.

  ConnectorOAuth

• anywayr_update_tripA

  AnywayrA

  Changes the dates or the number of travelers of a trip you can edit (the same edits the Anywayr website allows; budget, title and preference edits are refused for now). Requires the version you last read with anywayr_get_trip; a stale version is refused rather than overwritten. Multi-city date changes and child-leg party changes require the Anywayr website. Does not share, invite or book. Effects: Writes a new trip version.

  Connector

  Destructive

  OAuth

• publish_templateA

  KamyA

  Make a template version live for rendering. Called with no `version`, it snapshots the current draft into a new version and points published_version at it — this is how you ship an edit made with update_template. Called with an existing `version`, it republishes that earlier snapshot and leaves the draft alone. Reach for rollback_template instead when you are reverting a bad release: only that tool offers the concurrency fence and the option to restore the draft as well. Takes a template UUID or slug, same as every other /v1/templates route. Returns { templateId, publishedVersion, publishedVersionId, latestVersion, publishedAt }. Requires a Kamy API key with the `templates:write` scope; without a key, returns dashboard setup instructions.

  ConnectorNo auth

• publish_templateA

  KamyA

  Make a template version live for rendering. Called with no `version`, it snapshots the current draft into a new version and points published_version at it — this is how you ship an edit made with update_template. Called with an existing `version`, it republishes that earlier snapshot and leaves the draft alone. Reach for rollback_template instead when you are reverting a bad release: only that tool offers the concurrency fence and the option to restore the draft as well. Takes a template UUID or slug, same as every other /v1/templates route. Returns { templateId, publishedVersion, publishedVersionId, latestVersion, publishedAt }. Requires a Kamy API key with the `templates:write` scope; without a key, returns dashboard setup instructions.

  ConnectorNo auth

• get_bandwidth_statsA

  WebshareA

  Get bandwidth usage and request stats for one or more of the customer's plans. Use when customers ask about data usage, bandwidth consumption, or how many proxies/countries they're hitting. Each record in the response is scoped to a single plan_id and either contains `bandwidth`, `requests`, and `usage_summary` (successful fetch) or carries a `reason` field (plan_not_accessible / stats_service_unavailable) when that specific plan's fetch failed. Multi-plan customers: pass a list of plan ids. The response keeps one record per plan, in the order passed. Duplicate ids are silently deduped. The response carries no cross-plan totals; each field's description says which numbers are summable, which need recomputation from totals, and which should not be averaged. If one plan in the list fails, its record is a `FailedBandwidthStat` (plan_id + reason) and the other records still return data; the top-level `success` stays True.

  ConnectorOAuth

• mcp_crm_contacts_updateA

  MailzzyA

  Update a single existing contact for the authenticated tenant. Use when the user wants to change fields on ONE contact identified by its numeric contactId. Send only the fields you want to change plus the current version token (obtained from mcp_crm_contacts_get or mcp_crm_contacts_list). Settable fields: emailId, firstName, lastName, contactNo, address, country, city, state, postalCode, timezone, tagName. Reserved fields (status, score, ids, audit columns) cannot be set and the tenant is bound to the session (never a tool argument). Optimistic concurrency: if the contact changed since you fetched it you get a conflict — re-fetch the contact with mcp_crm_contacts_get for the current version and retry ONCE with the fresh version token. The server never auto-retries. The response echoes only the non-sensitive field set (id, email, name, status, createdOn, version) — address/phone/other allowlisted fields you set are persisted but NOT echoed; re-fetch via mcp_crm_contacts_get if you need to confirm them.

  ConnectorOAuth

• eol_statusA

  VigíaA

  Tells whether a language, runtime, framework, database or operating-system version is still supported and when it reaches end of life. Covers about 480 products (Python, Node.js, PHP, Java, Ruby, Go, Rust, Django, Laravel, Rails, React, Angular, PostgreSQL, MySQL, Ubuntu, Debian, Kubernetes and more). With product and version it returns that version's status (supported / security_only / end_of_life / upcoming), its release, active-support and end-of-life dates, days remaining or elapsed, and the cycles that are still supported; with only product it returns every release cycle; with neither it lists the product identifiers. Read-only and requires no authentication. Status is computed on every call from today's date; the dates come from endoflife.date and are refreshed every 12 hours. Use it before choosing a runtime or base image, when writing a Dockerfile or CI matrix, or when auditing an old version. It concerns the language, runtime or platform itself; for a library's own versions use package_status.

  ConnectorNo auth

• billing_budgetsA

  GreatWaitB

  Replaces the caller organization's advisory execution budget and optional hard execution-spend cap for the current UTC month. Values are exact whole cents encoded as integer microdollars. The expected budget-policy revision prevents a stale editor overwriting a newer choice, and Idempotency-Key makes retrying one intent safe. Null turns that setting off. This command records desired state durably; billing.reconcile advances it to PostgreSQL, and reads remain pending until PostgreSQL confirms it. It never changes automatic top-up authority, purchases credit, or counts subscription payments as execution usage.

  ConnectorOAuth

• search_providersA

  KaletoA

  Search current enrichment provider records by natural-language interests in a required region: pass the place the family names (city, neighborhood or area) or a region ID. Jev maps it onto a covered region in parallel with the activities, and the response region is the region searched; call list_regions only after LOCATION_UNSUPPORTED. Location words in the query are not used for filtering. Jev maps the query onto specific activities, PostgreSQL retrieves up to 120 providers in the region tagged with those activities, and Jev ranks them by relevance. Returns selected_types, relevance scores and limitations; does not verify program availability. All callers share the same search rate and concurrency limits. Search text is processed by Jev; operational search analytics are stored. Do not include child names or private details.

  ConnectorNo auth

• search_providersA

  KaletoA

  Search current enrichment provider records by natural-language interests in a required region: pass the place the family names (city, neighborhood or area) or a region ID. Jev maps it onto a covered region in parallel with the activities, and the response region is the region searched; call list_regions only after LOCATION_UNSUPPORTED. Location words in the query are not used for filtering. Jev maps the query onto specific activities, PostgreSQL retrieves up to 120 providers in the region tagged with those activities, and Jev ranks them by relevance. Returns selected_types, relevance scores and limitations; does not verify program availability. All callers share the same search rate and concurrency limits. Search text is processed by Jev; operational search analytics are stored. Do not include child names or private details.

  ConnectorNo auth

• account_usageA

  zenrows-mcpA

  Read the current plan's credit allowance and how much of it is spent. Useful before a large batch, or after a 402 / AUTH004, to see whether the account has credits left and when the allowance renews. The call is free and does not use a concurrency slot. Credit costs per request: 1 basic, 5 js_render, 10 premium_proxy, 25 both. AUTH004 ("usage exceeded") means this allowance is spent until it renews at the end of the billing period (period_ends_at in this tool's response). Plans and credit options are described at https://www.zenrows.com/pricing. AUTH006 is the concurrency limit, not a credit limit. AUTH014 (Batch: api_key_cap_reached) means this API key hit one of its own credit caps while the account still has credits; other keys keep working. The response's api_key.caps lists the calling key's caps: window, credits, used_credits, remaining_credits, resets_at, and unavailable (usage could not be read). Caps are managed at https://app.zenrows.com/settings/api-keys.

  ConnectorOAuth

• sixta_analyze_schema_changeA

  sixta-connectA

  Call this whenever the user proposes a migration / DDL change or asks 'is this safe to run' — before answering from memory. Whether a migration locks the table is version-specific (exactly which MySQL 8.0.x or PostgreSQL version makes an ALTER lock-free, INSTANT vs INPLACE vs COPY eligibility), and model recall of those version boundaries is unreliable — this is where answering from memory most often ships an outage. Returns an explicit safety verdict per statement (Critical/High/Medium/Info), the exact lock taken and what it blocks, the MySQL algorithm verdict with version-specific eligibility, PostgreSQL rewrite triggers, replication and MDL-starvation warnings, and the safe execution strategy (CREATE INDEX CONCURRENTLY, NOT VALID + VALIDATE, gh-ost / pt-osc) as ready-to-run SQL. Optional table size/FK/trigger hints sharpen duration estimates; for entitled Connect Pro orgs these are filled from live production context automatically (an explicit argument still wins). Findings are deterministic, treat them as ground truth. Input is analyzed in memory and never stored.

  ConnectorOAuth

• get_latest_releaseA

  canton-ccpediaA

  Get the single latest release (version tag, publish date, and GitHub release-notes link) for ONE NAMED Canton-ecosystem package: canton, daml, dpm, or splice. Canton-specific. Requires a package name as input. Use when the user names a specific package ("what's the latest daml release", "latest canton version"); use get_current_versions instead for a cross-package snapshot of all four at once or MainNet/TestNet deployment status.

  ConnectorNo auth

• check_creditsA

  Easyparser — Amazon Product & Seller DataA

  Check the Easyparser account: current plan, credit balance (used/remaining/limit), credit reset date, per-minute rate limits, and this month's daily usage breakdown by operation. FREE — this calls the Account API and consumes no credits. Use this before running expensive multi-page or 12-month-history jobs, when the user asks about their quota or plan, or to analyze usage patterns (e.g. 'which operation consumed the most credits this month?'). Requires an API key.

  ConnectorNo auth

• get_componentA

  PCFHubA

  Everything about one control by its slug: what it does, its control type, license and repository, the current release's properties, and download links for its solutions. Use it once search or list_components has given you a slug; use get_doc_page for installation and configuration instructions, which this does not return. An unknown slug, or a version the control never released, returns an error naming the tool to call instead. include_versions and include_related each cost an extra query, so leave them off unless you need the release history or similar controls.

  ConnectorNo auth

• list_releasesA

  PCFHubA

  The most recent releases across every control on PCFHub, newest first: which control, which version, whether it is a prerelease, and when it shipped. Use it for what has changed hub-wide; for one control's own history call get_component with include_versions instead. Bounded by limit, at most 50, and not paged — there is no cursor, so it cannot walk back beyond the newest 50.

  ConnectorNo auth

• validate_manifestA

  PCFHubA

  Check a pcfhub.json against the rules PCFHub applies when it publishes a control: the schema version, the control block (namespace, constructor, type and framework), the demo's fidelity, bundle and presets, the media files it declares, and the release artifacts it expects to find. Use it while writing or reviewing that file, before a release is tagged. An invalid manifest is an ordinary result — valid false, with errors that block publishing and warnings that do not, each carrying the JSON pointer it applies to — so read the result rather than retrying. Only an empty, unreadable or oversized manifest (over 64 KB) is an error.

  ConnectorNo auth

• get_helpA

  BotKelpA

  Free, no API key. Usage + full component catalog as TSV (id, name, version, description, provides, requires, conflictsWith). Call this first. Prefer resource botkelp://catalog if your client supports it.

  ConnectorNo auth

• get_eol_statusA

  Dev Facts CheckA

  Get end-of-life status. Use this when the user asks whether a software version is still supported or when it reaches end of life, such as "is Node.js 20 still supported?" or "which Python versions get security fixes?". Pass the product (nodejs, python, ubuntu, postgresql and so on) and optionally a version or release cycle. With a version it returns that cycle's end-of-life date, whether it has passed, LTS dates and the latest patch. Without one it returns the release cycles that are still supported. Data comes from endoflife.date, maintained by volunteers: confirm with the vendor for contract or compliance decisions. Not for package vulnerabilities.

  ConnectorNo auth

• zenodo_list_versionsA

  zenodo-mcp-serverA

  List every version of a Zenodo deposit's version series, newest first, with each version's record id, DOI, version label, publication date, file totals, and usage counts. Accepts any identifier zenodo_get_record accepts; a concept DOI and any single version's DOI list the same series. Use it to find the version a paper cited or the current release. A miss (an unknown id, a deleted record with its removal tombstone, restricted metadata, or a DOI not registered on Zenodo) returns found: false with guidance instead of an error.

  ConnectorNo auth

• query_app_databaseA

  Roar AIA

  Run ONE read-only SQL statement against a hosted app's own PostgreSQL database, in the PostgreSQL SQL dialect (https://www.postgresql.org/docs/current/sql.html). Writes are refused by the database itself. Returns immediately with a runId; the rows are fetched with get_query_result. Table and column names come from get_app_database_schema, because the app's schema is its own, not ours.

  ConnectorOAuth