# PopSQL Data Catalog API

**Canonical:** https://apis.io/apis/popsql/popsql-data-catalog-api/  
**Provider:** PopSQL — https://apis.io/providers/popsql/  
**Base URL:** https://api.popsql.com/v1  
**Documentation:** https://docs.popsql.com/reference

PopSQL Data Catalog API is one of 2 APIs that [PopSQL](https://apis.io/providers/popsql/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. This API exposes 4 JSON Schema definitions. Tagged areas include Data Catalog. The published artifact set on APIs.io includes an OpenAPI specification and 4 JSON Schemas.

The Data Catalog API from PopSQL — 7 operation(s) for data catalog.

## Operations (12)

| Method | Path | Summary |
|---|---|---|
| GET | `/connections/{connection_id}/catalog` | Get Connection catalog |
| PATCH | `/connections/{connection_id}/catalog` | Update Connection catalog |
| GET | `/connections/{connection_id}/catalog/columns` | Search columns |
| GET | `/connections/{connection_id}/catalog/tables` | Search tables |
| GET | `/connections/{connection_id}/databases/{database_name}/catalog` | Get database catalog |
| PATCH | `/connections/{connection_id}/databases/{database_name}/catalog` | Update database catalog |
| GET | `/connections/{connection_id}/databases/{database_name}/schemas/{schema_name}/catalog` | Get schema catalog |
| PATCH | `/connections/{connection_id}/databases/{database_name}/schemas/{schema_name}/catalog` | Update schema catalog |
| GET | `/connections/{connection_id}/databases/{database_name}/schemas/{schema_name}/tables/{table_name}/catalog` | Get table catalog |
| PATCH | `/connections/{connection_id}/databases/{database_name}/schemas/{schema_name}/tables/{table_name}/catalog` | Update table catalog |
| GET | `/connections/{connection_id}/databases/{database_name}/schemas/{schema_name}/tables/{table_name}/columns/{column_name}/catalog` | Get column catalog |
| PATCH | `/connections/{connection_id}/databases/{database_name}/schemas/{schema_name}/tables/{table_name}/columns/{column_name}/catalog` | Update column catalog |

## Machine-readable artifacts (6)

- **OpenAPI** — https://artifacts.apis.io/popsql/openapi/popsql-data-catalog-api-openapi.yml
- **JSONSchema** — https://artifacts.apis.io/popsql/json-schema/popsql-table-search-result-schema.json
- **JSONSchema** — https://artifacts.apis.io/popsql/json-schema/popsql-column-search-result-schema.json
- **JSONSchema** — https://artifacts.apis.io/popsql/json-schema/popsql-update-column-request-schema.json
- **JSONSchema** — https://artifacts.apis.io/popsql/json-schema/popsql-update-table-request-schema.json
- **APIsJSON** — https://artifacts.apis.io/popsql/apis.yml

## Other PopSQL APIs (1)

- [PopSQL Query Runs API](https://apis.io/apis/popsql/popsql-query-runs-api/)

## Tags

Data Catalog

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/popsql/popsql-data-catalog-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/popsql/.