Metadata API

The Metadata API lets you explore the structure of PostgreSQL, MongoDB, and vector databases managed by the platform. Use these endpoints to discover what data is available before writing queries or running searches.

PostgreSQL

List Databases

GET /api/v1/metadata/postgres/databases

Returns a JSON array of PostgreSQL database names.

List Schemas

GET /api/v1/metadata/postgres/schemas

Parameter	Type	Default	Description
`database`	query	`datris`	Database name

Returns a JSON array of schema names. System schemas (information_schema, pg_catalog, pg_toast) are excluded.

List Tables

GET /api/v1/metadata/postgres/tables

Parameter	Type	Default	Description
`database`	query	`datris`	Database name
`schema`	query	`public`	Schema name
`vectorOnly`	query	`false`	If `true`, return only pgvector tables (tables with an `embedding` column)

Returns a JSON array of table names. When vectorOnly is false, pgvector tables are excluded from the results.

List Columns

GET /api/v1/metadata/postgres/columns

Parameter	Type	Default	Description
`database`	query	`datris`	Database name
`schema`	query	`public`	Schema name
`table`	query	(required)	Table name

Returns a JSON array of column definitions:

[
  {"name": "id", "type": "bigint"},
  {"name": "email", "type": "text"},
  {"name": "created_at", "type": "timestamp"}
]

MongoDB

List Databases

GET /api/v1/metadata/mongodb/databases

Returns a JSON array of MongoDB database names. System databases (admin, config, local) and the platform’s internal database are excluded.

List Collections

GET /api/v1/metadata/mongodb/collections

Parameter	Type	Default	Description
`database`	query	(all databases)	Filter to a specific database

When database is provided, returns collection names from that database. When omitted, returns collections from all databases with a database.collection namespace prefix.

Vector Stores

List Qdrant Collections

GET /api/v1/metadata/qdrant/collections

Returns a JSON array of Qdrant collection names. Returns [] if Qdrant is not configured.

List Weaviate Classes

GET /api/v1/metadata/weaviate/classes

Returns a JSON array of Weaviate class names. Returns [] if Weaviate is not configured.

List Milvus Collections

GET /api/v1/metadata/milvus/collections

Returns a JSON array of Milvus collection names. Returns [] if Milvus is not configured.

List Chroma Collections

GET /api/v1/metadata/chroma/collections

Returns a JSON array of Chroma collection names. Returns [] if Chroma is not configured.

Example

# Discover databases
curl -s http://localhost:8080/api/v1/metadata/postgres/databases | jq .

# Explore a schema
curl -s "http://localhost:8080/api/v1/metadata/postgres/tables?database=datris&schema=public" | jq .

# Inspect a table
curl -s "http://localhost:8080/api/v1/metadata/postgres/columns?table=stock_prices" | jq .

# List vector collections
curl -s http://localhost:8080/api/v1/metadata/qdrant/collections | jq .

API Documentation

Pipelines

Ingestion

AI

Status

Query

Search

Metadata

Configuration

Health

Secrets

Taps

Code repository

Versions

Auth

API Keys

Assistant

Chat

MCP

Tap Prompts

PostgreSQL

List Databases

List Schemas

List Tables

List Columns

MongoDB

List Databases

List Collections

Vector Stores

List Qdrant Collections

List Weaviate Classes

List Milvus Collections

List Chroma Collections

Example

​PostgreSQL

​List Databases

​List Schemas

​List Tables

​List Columns

​MongoDB

​List Databases

​List Collections

​Vector Stores

​List Qdrant Collections

​List Weaviate Classes

​List Milvus Collections

​List Chroma Collections

​Example

PostgreSQL

List Databases

List Schemas

List Tables

List Columns

MongoDB

List Databases

List Collections

Vector Stores

List Qdrant Collections

List Weaviate Classes

List Milvus Collections

List Chroma Collections

Example