---
title: "Get Available Databases"
method: GET
path: "/data_stores/{data_store_id}/available_databases"
tags: ["DATA_STORE"]
---

# Get Available Databases

`GET /data_stores/{data_store_id}/available_databases`

## Request

- Base URL: `https://api.myaltimate.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.myaltimate.com/data_stores/{data_store_id}/available_databases`
- Auth: one of:
  - HTTP bearer
  - HTTP bearer

Gets available databases for a data store by id.
This endpoint fetches all databases from the data store's connection and filters out
the ones that are already in use by other data stores of the same type.

:param data_store_id: The ID of the data store to fetch databases for
:return: A dictionary containing used and unused databases

## Path parameters

- `data_store_id` integer, required

## Response `200`

Successful Response

- AvailableDatabasesResponse
  - `used_databases` string[], required
  - `unused_databases` string[], required

## Other responses

- `400`: Invalid data store id
- `403`: Not supported for public user
- `404`: Data store not found
- `422`: Validation Error
- `500`: Failed to fetch available databases

---

[API](https://skmtc.dev/myaltimate/apis/myaltimate-api.md) - [All operations](https://skmtc.dev/myaltimate/apis/myaltimate-api/llms.txt) - [OpenAPI document](https://skmtc.dev/myaltimate/apis/myaltimate-api/revisions/727657ce54e9?raw)