---
title: "Get connection details"
method: GET
path: "/api/v1/databases/{database_id}/connection"
tags: ["Managed Databases"]
---

# Get connection details

`GET /api/v1/databases/{database_id}/connection`

Connection details for the database: host, port, username, database name, and a ready-to-use connection URI.

The `password` field is empty unless you pass `reveal=true`. TLS is always required.

## Path parameters

- `database_id` string, required

## Query parameters

- `reveal` boolean

## Response `200`

Connection details

- object
  - `success` boolean
  - `host` string — Endpoint hostname
  - `port` integer — Endpoint port
  - `username` string — Database user
  - `password` string — Password — empty unless the request was made with `reveal=true`
  - `database_name` string — Default database name
  - `connection_uri` string — Ready-to-use connection URI (includes the password only when revealed)
  - `ca_cert` string — PEM CA bundle your client must trust, for engines whose certificates come from a private CA (currently Kafka). Empty for other engines.

## Other responses

- `401` — Authentication required
- `404` — Resource not found

---

[API](https://skmtc.dev/rafftechnologies/apis/raff-api.md) · [All operations](https://skmtc.dev/rafftechnologies/apis/raff-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/rafftechnologies/raff-api/revisions/2f4df56be77c/schema)