# Managing databases from the API

## Getting database information

### Getting all of the databases in a workspace

To list all of the databases in a specific workspace:

```
GET /api/v1/workspaces/:workspace_name/databases
```

The response contains an array of database objects. For each database, the database object contains the following fields:

{% code overflow="wrap" %}

```json
[
  {
    "id": "c50db909-6617-40d8-8c81-47de1b2e9806",
    "name": "CREATED_FROM_API",
    "created_at": "2025-03-20T08:44:41Z",
    "updated_at": "2025-03-20T08:44:42Z",
    "last_generated": "2025-03-20T08:44:42Z",
    "data_url": "http://fabricate.tonic.ai/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsiZGF0YSI6IjFjMTg5MjNmLWZkZDAtNDRhZC04Y2U5LTE3Mjk5ZTBkNDEyNCIsInB1ciI6ImJsb2JfaWQifX0=--c9d77fa2a060bfd8c90813f960a901d7ea75c7c1/CREATED_FROM_API.zip",
    "workspace": {
      "id": "7edef645-87a5-46ef-9ea1-cce33cd9a543",
      "name": "Fabricate"
    },
  }
]
```

{% endcode %}

Where:

<table data-header-hidden><thead><tr><th width="175.2890625" valign="top"></th><th valign="top"></th></tr></thead><tbody><tr><td valign="top"><code>id</code></td><td valign="top">The UUID of the database.</td></tr><tr><td valign="top"><code>name</code></td><td valign="top">The name of the database.</td></tr><tr><td valign="top"><code>created_at</code></td><td valign="top">The date and time when the database was created.</td></tr><tr><td valign="top"><code>updated_at</code></td><td valign="top">The date and time the database configuration was most recently updated.</td></tr><tr><td valign="top"><code>last_generated</code></td><td valign="top">The date and time that the database data was most recently generated.</td></tr><tr><td valign="top"><code>data_url</code></td><td valign="top">The URL to download the most recently generated data.<br><br>Until the data is generated, this is null.</td></tr><tr><td valign="top"><code>workspace</code></td><td valign="top">The identifier and name of the workspace that the database belongs to.</td></tr></tbody></table>

For an example, go to [list-databases.js](https://github.com/mockaroo/fabricate-api-examples/blob/main/js/list-databases.js) in the `fabricate-api-examples` GitHub repository.

### Getting details for a specific database

To get the details for a specific database by name:

```
GET /api/v1/workspaces/:workspace_name/databases/:database_name
```

The response is a database object with the full details about the database configuration.

For an example, go to [get-database.js](https://github.com/mockaroo/fabricate-api-examples/blob/main/js/get-database.js) in the `fabricate-api-examples` GitHub repository.

## Creating and managing database configuration

### Creating or updating a database

To create a database or update an existing database:

```
POST /api/v1/workspaces/:workspace_name/databases
```

The request body is a database object with the database configuration.

The response contains a database object with the new or updated database configuration.

For an example, go to [upsert-database.js](https://github.com/mockaroo/fabricate-api-examples/blob/main/js/upsert-database.js) in the `fabricate-api-examples` GitHub repository.

### Deleting a database <a href="#delete-a-database" id="delete-a-database"></a>

To delete a database:

```
DELETE /api/v1/workspaces/:workspace_name/databases/:database_name
```

Returns an empty response body with a 200 status code.

For an example, go to [delete-database.js](https://github.com/mockaroo/fabricate-api-examples/blob/main/js/delete-database.js) in the `fabricate-api-examples` GitHub repository.

## Adding static data to a table

In Fabricate, instead of generating the data for a table, you can provide static data in the form of a .csv file.

From the API, to update the .csv file content:

{% code overflow="wrap" %}

```
POST /api/v1/workspaces/:workspace_name/databases/:database_name/entities/:table_name/source
```

{% endcode %}

This method expects a multipart/form-data request body with a `file` parameter that contains the contents of the .csv file to use for the table data.

The response contains an empty response body with a 200 code.

For an example, go to [update-source-data.js](https://github.com/mockaroo/fabricate-api-examples/blob/main/js/update-source-data.js) in the `fabricate-api-examples` GitHub repository.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tonic.ai/fabricate/fabricate-api-and-cli/using-the-fabricate-api/managing-databases-from-the-api.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.