Vertica

Vertica (now branded OpenText Analytics Database) is a high-performance, columnar, MPP analytics database designed for petabyte-scale data warehousing, data lakehouse, and advanced analytics workloads across on-premises, cloud, and Kubernetes deployments. The platform delivers in-database machine learning, geospatial and time-series analytics, separation of storage and compute, and broad SQL compatibility. Vertica exposes a REST API via the Node Management Agent (NMA) for programmatic cluster and database operations authenticated with mutual TLS.

Vertica publishes 3 API contracts indexed on the APIs.io network, including Health API, Lifecycle API, and 1 more. Tagged areas include Database, Analytics Database, Data Warehouse, Data Lakehouse, and Columnar Database.

The Vertica catalog on APIs.io includes 1 Spectral governance ruleset.

Vertica’s developer surface includes authentication, documentation, support, and 10 more developer resources.

🌐 Visit website 📡 Profile data on GitHub

22.9/100 emerging ▬ flat Agent 27/100 agent aware Front door AI 6/6 dominant Heartbeat 73/100 slowing Full breakdown ↓
scored 2026-11-13 · rubric v0.28.0 · Show this score on your site →

AccessApproval

1 published contract

DatabaseAnalytics DatabaseData Warehouse Data LakehouseColumnar DatabaseMPPIn-Database Machine LearningSQL

Kin Score

Kin Score How this is scored →
scored 2026-11-13 · rubric v0.28.0

Composite quality — 22.9/100 · emerging

Contract Quality 8.2 / 19

Developer Ergonomics 3.9 / 15

Access Clarity 0.0 / 15

Operational Transparency 0.5 / 10

Contract Governance 1.2 / 9

Discoverability 5.0 / 8

Regulatory Posture 0.9 / 15

Create-or-Update Ergonomics 0.0 / 10

Agent readiness — 27/100 · agent aware

Machine-Readable Contract 18 / 18

Agentic Access Contract 10 / 10

Documented Reversibility 0 / 6

MCP Server 0 / 12

Machine-Readable Auth 10 / 10

Idempotency 0 / 9

Stable Error Semantics 0 / 8

Request/Response Examples 7 / 7

Rate-Limit Signaling 0 / 7

Typed Event Surface 0 / 6

Agent Skills 0 / 5

Well-Known Catalog 0 / 4

Consent & Bot Identity 0 / 3

A2A Agent Card 0 / 8

Dry-Run / Simulate Mode 0 / 4

Delegated User Identity 0 / 6

Protected Resource Metadata 0 / 5

Registration Without a Human 0 / 6

Agentic Commerce Well-Known Document 0 / 5

Pagination 5 / 5

Distinct Operations 3 / 3

MCP Tool Quality 6 / 6

Regulatory Posture applies to this provider. Its tags matched the Horizontal (data, software, accessibility, platform) regime, so Regulatory Posture carries 15 points of the composite. If this regime is wrong for your business, say so on your provider repo — the applicability map is public and we will correct it.

Create-or-Update Ergonomics applies to this provider. This API accepts writes, so it carries 10 points of the composite. It is scored from the published contracts themselves: whether a caller can create-or-update in one call, whether the write accepts a key the caller already holds, and whether the response says which branch ran. Without that, every write needs a search-and-branch in front of it, and the first time that check is skipped a duplicate record is created. Scored against the observed mean rather than raw — a provider at the catalog average is unchanged by this facet, not penalised by it.

The six quality facets above are damped to 75 points between them, because the conditional facet above carries the other 25. That is why each facet's contribution is shown against a damped maximum: raising a quality facet moves the composite by 75% of its nominal weight, not 100%. The full arithmetic is at apis.io/rating/.

Show this score on your site.

It updates itself when the score changes. Paste this where you link to your API docs:

<a href="https://apis.io/providers/vertica/"><img src="https://apis.io/badge/vertica/card.svg" alt="Vertica on APIs.io — Kin Score by API Evangelist"></a>

Other styles, a README pill and a shields.io endpoint are on the badge page.

Raise your score.

Agent readiness — checks not met, largest first (exact, from this profile):

MCP Server +12 pts — deployment.mode + probe verdict on the mcp/ manifest, not the pointer; an unprobed slug falls back to authorship Ask about this →
Idempotency +9 pts — OpenAPI mutating operations declare an idempotency key — a header, a request-body property, or a named de-duplication token whose own description says so (verified); else common[].type matches /idempoten/i (documented) Ask about this →
Stable Error Semantics +8 pts — OpenAPI $refs a shared error schema across 4xx/5xx responses (verified), else common[].type includes ErrorCatalog / ErrorCodes / DeclineCodes Ask about this →
A2A Agent Card +8 pts — a2a/-a2a.yml manifest, graded on conformance.grade against A2A 1.0.0 Ask about this →
Rate-Limit Signaling +7 pts — OpenAPI responses document X-RateLimit-* / RateLimit headers (verified), else a rate_limits artifact or RateLimits link (documented) Ask about this →
Registration Without a Human +6 pts — a `registration_endpoint` in the served RFC 8414 / OIDC discovery document Ask about this →

9 more unmet checks in the Agent Readiness table above.

Kin Score — facets with the most composite points still available (weight × headroom):

Access Clarity scores 0.0 — up to +20.0 composite points Ask about this →
Developer Ergonomics scores 26.2 — up to +14.8 composite points Ask about this →
Contract Quality scores 43.5 — up to +14.1 composite points Ask about this →

Each check links to what satisfies it. Publish the artifact, or tell us where it already lives, and the score moves on the next scoring run.

Not sure how this applies to your stack? Ask about any one item. Kin Lane reads every question, looks at your profile and your situation, and replies with what a fix would take — scoped to that one area, priced up front, yours whether you ship it or not. Ask a question →

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. Every facet and dimension name above is a link: it opens that measurement's own page — what it means, the exact checks that feed it, how the whole catalog distributes on it, and the providers at the top of it. This rating is computed from the provider profile at artifacts.apis.io/vertica/apis.yml: open an issue on github.com/api-evangelist/vertica to ask a question or point us at an artifact you publish. Submit an artifact on GitHub — free → Manage your own listing — the Influence plan, $499/mo →

Standards implemented 3

Standards this provider implements or carries. De facto ones are profiled and measured by the API Commons; formal ones come from the standards directory and are linked by the provider's own tags. The evidence column says how each claim was established — not that it was made.

Machine Payments Protocol (MPP)

tagged — the provider's own APIs.json carries the standard as a tag; implementation not verified

OpenAPI

measured — observed by APIs.io (published)

Mutual TLS

measured — observed by APIs.io (declared)

APIs 3

Individual APIs this provider publishes, each with its own machine-readable definition.

Vertica Management Console REST API

Agent-backed REST API used by Vertica Management Console for monitoring, provisioning, and managing Vertica databases and clusters. Returns JSON responses for node, database, an...

Vertica Health API

The Health API from Vertica — 1 operation(s) for health.

Vertica Lifecycle API

The Lifecycle API from Vertica — 1 operation(s) for lifecycle.

Open Collections 3

Open, tool-agnostic API collections (OpenAPI-derived and Bruno).

Vertica Node Management Agent (NMA) Health API

OPEN COLLECTION

Vertica Node Management Agent (NMA) Health Lifecycle API

OPEN COLLECTION

Vertica Node Management Agent (NMA) API

OPEN COLLECTION

Spectral Rules 1

Spectral governance rulesets for linting and validating these APIs. Counts are the severity each rule declares, not results of running them.

Vertica API Rules

36 rules · 34 error-severity 1 warn-severity 1 info-severity

SPECTRAL

Security Posture 2

Authentication, domain security, vulnerability disclosure, and trust-center signals.

Vertica Authentication

mutualTLS · 1 scheme

SECURITY

Vertica Domain Security

TLSv1.3 · DMARC

SECURITY

Agentic Access (API Evangelist recommendations) 1

Recommended x-agentic-access execution contracts for AI agents.

Vertica Agentic Access

2 operations · 1 acting · 1 human-in-the-loop

2 operations · 1 acting

AGENTIC

Resources

Documentation 1

Reference material describing how the API behaves

Documentation

Documentation

Agent Surfaces 1

MCP servers, agent skills, and machine-readable catalogs

AgenticAccess

AgenticAccess

Build 2

SDKs, sample code, and the tooling you integrate with

GitHubOrganization

GitHubOrganization

GitHub vcluster

GitHub vcluster

Access & Security 2

Authentication, authorization, and security posture

DomainSecurity

DomainSecurity

Authentication

Authentication

Operate 3

Status, limits, changes, and where to get help

Community Edition

Community Edition

Community

Community

Support

Support

Company 2

The organization behind the API

LinkedIn

Website

Website

Other 2

Properties that don't map to a standard resource type

Product Page

Product Page

Parent Company

Parent Company

Source (apis.yml)

aid: vertica
name: Vertica
description: Vertica (now branded OpenText Analytics Database) is a high-performance, columnar, MPP analytics database designed
  for petabyte-scale data warehousing, data lakehouse, and advanced analytics workloads across on-premises, cloud, and Kubernetes
  deployments. The platform delivers in-database machine learning, geospatial and time-series analytics, separation of storage
  and compute, and broad SQL compatibility. Vertica exposes a REST API via the Node Management Agent (NMA) for programmatic
  cluster and database operations authenticated with mutual TLS.
type: Index
deliveryModel:
  model: unknown
  open_source: false
  commercial: false
  callable_host: false
  label: Delivery model not determined — needs a product licence on record
  confidence: low
  source:
  - openapi
  generated: '2026-08-28'
  method: derived
accessModel:
  pricing: unknown
  onboarding: approval
  trial: false
  try_now: false
  public: false
  label: Requires approval
  confidence: low
  source:
  - authentication
  - security
  - url: https://www.vertica.com
    status: 301
    note: declared website redirects to https://www.rocketsoftware.com/en-us/products/vertica?o=vert — a different registrable
      domain (vertica.com -> rocketsoftware.com), possible rename or acquisition (probed 2026-09-03, roadmap#169)
  generated: '2026-11-13'
  method: derived
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/vertica.png
tags:
- Database
- Analytics Database
- Data Warehouse
- Data Lakehouse
- Columnar Database
- MPP
- In-Database Machine Learning
- SQL
url: https://raw.githubusercontent.com/api-evangelist/vertica/refs/heads/main/apis.yml
created: '2026-05-11'
modified: '2026-05-11'
specificationVersion: '0.23'
apis:
- aid: vertica:management-console-api
  name: Vertica Management Console REST API
  description: Agent-backed REST API used by Vertica Management Console for monitoring, provisioning, and managing Vertica
    databases and clusters. Returns JSON responses for node, database, and cluster operations.
  humanURL: https://docs.vertica.com/latest/en/connecting-to/management-api/rest-apis-agent/
  baseURL: https://<management-host>:5444
  tags:
  - Management Console
  - Monitoring
  - Provisioning
  properties:
  - type: Documentation
    url: https://docs.vertica.com/latest/en/connecting-to/management-api/rest-apis-agent/
- aid: vertica:vertica-health-api
  name: Vertica Health API
  description: The Health API from Vertica — 1 operation(s) for health.
  humanURL: https://docs.vertica.com/latest/en/admin/managing-db/node-management-agent/
  baseURL: https://<node-host>:5554
  tags:
  - Health
  properties:
  - type: OpenAPI
    url: openapi/vertica-health-api-openapi.yml
  - type: Documentation
    url: https://docs.vertica.com/latest/en/admin/managing-db/node-management-agent/
  - type: Endpoints Reference
    url: https://docs.vertica.com/latest/en/admin/managing-db/node-management-agent/nma-endpoints/
  - type: Authentication
    url: https://docs.vertica.com/latest/en/admin/managing-db/node-management-agent/custom-certificates/
- aid: vertica:vertica-lifecycle-api
  name: Vertica Lifecycle API
  description: The Lifecycle API from Vertica — 1 operation(s) for lifecycle.
  humanURL: https://docs.vertica.com/latest/en/admin/managing-db/node-management-agent/
  baseURL: https://<node-host>:5554
  tags:
  - Lifecycle
  properties:
  - type: OpenAPI
    url: openapi/vertica-lifecycle-api-openapi.yml
  - type: Documentation
    url: https://docs.vertica.com/latest/en/admin/managing-db/node-management-agent/
  - type: Endpoints Reference
    url: https://docs.vertica.com/latest/en/admin/managing-db/node-management-agent/nma-endpoints/
  - type: Authentication
    url: https://docs.vertica.com/latest/en/admin/managing-db/node-management-agent/custom-certificates/
common:
- type: AgenticAccess
  url: agentic-access/vertica-agentic-access.yml
- type: DomainSecurity
  url: security/vertica-domain-security.yml
- type: Authentication
  url: authentication/vertica-authentication.yml
- type: LinkedIn
  url: https://www.linkedin.com/showcase/vertica-co
- type: Website
  url: https://www.vertica.com
- type: Product Page
  url: https://www.opentext.com/products/analytics-database
- type: Documentation
  url: https://docs.vertica.com/
- type: Community Edition
  url: https://docs.vertica.com/latest/en/getting-started/community-edition-ce/
- type: Community
  url: https://community.opentext.com/data-analytics/analytics-db
- type: GitHubOrganization
  url: https://github.com/vertica
- type: GitHub vcluster
  url: https://github.com/vertica/vcluster
- type: Support
  url: https://www.opentext.com/support
- type: Parent Company
  url: https://www.opentext.com/
maintainers:
- FN: Kin Lane
  email: kin@apievangelist.com

Vertica API — frequently asked questions

Does Vertica have an API?

Yes. APIs.io lists 3 APIs from Vertica, including Vertica Management Console REST API, Vertica Health API and Vertica Lifecycle API.

Is there an OpenAPI specification for the Vertica API?

Yes. APIs.io indexes 2 OpenAPI specifications for Vertica, each linked for download from this page.

How do I authenticate with the Vertica API?

Vertica documents its authentication (mutualTLS · 1 scheme). The details are profiled on APIs.io as Vertica Authentication.

Is the Vertica API ready for AI agents?

Vertica has a Kin Score of 22.9 out of 100 (emerging) and an Agent Readiness score of 27.0 (agent-aware), scored by API Evangelist on 2026-11-13.

Work with this as data

Every provider here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for providers

9 MCP tools reach this

find_providersBrowse and filter every provider in the catalog.
get_provider_artifactsEvery artifact this provider publishes, grouped by type.
get_provider_operationsEvery operation across all of their OpenAPIs — one call instead of parsing every spec.
get_provider_toolsEvery MCP tool they ship, with the operation each wraps.
get_provider_evidenceHow each part of their score was established. Free — the basis for a claim should not sit behind it.
get_provider_ratingPRO — composite, band, trend and facet scores.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This provider

curl "https://apis.io/api/v1/providers/vertica"

All providers

curl "https://apis.io/api/v1/providers?limit=25"

Every operation they expose

curl "https://apis.io/api/v1/providers/vertica/operations?limit=25"

How their score was established

curl "https://apis.io/api/v1/providers/vertica/evidence"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.