# Halo Connect SQL Passthrough API

**Canonical:** https://apis.io/apis/halo-connect/halo-connect-sql-passthrough-api/  
**Provider:** Halo Connect — https://apis.io/providers/halo-connect/  
**Base URL:** https://api.haloconnect.io  
**Documentation:** https://docs.haloconnect.io/halo-cloud/overview/

Halo Connect SQL Passthrough API is one of 5 APIs that [Halo Connect](https://apis.io/providers/halo-connect/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include SQL Passthrough. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and an API reference.

Send SQL queries to practices as immediate, async or registered queries. **Immediate queries** are small, time-sensitive queries that return a result in seconds. Response size is limited to 8MB. **Async queries** are queued for execution and results can be retrieved later. The workflow is: 1. **Submit async query** – Creates a query and returns a `queryId` on success. 2. **Get query status** – Check query status. When complete, includes pagination details. 3. **Get query result page** – Retrieve result pages using the pagination info from the status response. **Registered Queries** are also supported. See the [Registered Queries](#tag/Registered-Queries) section for more information.

## Machine-readable artifacts (6)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/halo-connect/refs/heads/main/openapi/halo-connect-sql-passthrough-api-openapi.yml
- **Documentation** — https://docs.haloconnect.io/halo-cloud/overview/
- **APIReference** — https://docs.haloconnect.io/api-reference/integrator-openapi.html
- **APIReference** — https://docs.haloconnect.io/api-reference/desktop-openapi.html
- **Documentation** — https://docs.haloconnect.io/halo-cloud/fhir-api/overview/
- **Documentation** — https://docs.haloconnect.io/halo-cloud/fhir-api/capabilities/

## Other Halo Connect APIs (4)

- [Halo Connect FHIR API](https://apis.io/apis/halo-connect/halo-connect-fhir-api/)
- [Halo Connect Registered Queries API](https://apis.io/apis/halo-connect/halo-connect-registered-queries-api/)
- [Halo Connect Sites API](https://apis.io/apis/halo-connect/halo-connect-sites-api/)
- [Halo Connect Tokens API](https://apis.io/apis/halo-connect/halo-connect-tokens-api/)

## Tags

SQL Passthrough

---

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