---
title: "Dump a space's database rows"
method: GET
path: "/v1/spaces/{spaceId}/db/dump"
tags: ["Database"]
---

# Dump a space's database rows

`GET /v1/spaces/{spaceId}/db/dump`

## Request

- Base URL: `https://api.spacefast.com`
- URL: `https://api.spacefast.com/v1/spaces/{spaceId}/db/dump`
- Auth: one of:
  - HTTP bearer
  - HTTP bearer

Returns rows from the live capsule's declared tables for debugging and export. Reads the space's own MySQL through its runtime, so this route answers only while that runtime is reachable. This route is Zero-kind only for the same reason as `/db`: workers do not declare a table set. Use `db console` for worker tables.

## Path parameters

- `spaceId` string, required

## Query parameters

- `table` string: Dump only this declared table. Omit it to dump every declared table.
- `limit` integer: Maximum rows to read per table. Send `0` to read only each table's `rowCount`.

## Response `200`

Response for status 200

- object
  - `$schema` string, uri: Canonical JSON Schema URL for this response body. The server also sends it in the `Link: rel="describedby"` response header.
  - `data` object, required
    - `versionId` string, nullable, required
    - `artifactId` string, nullable, required
    - `schemaHash` string, nullable, required
    - `tables` object[], required
      - `name` string, required
      - `rowCount` integer, nullable, required: Total rows in the table. The limit does not bound this value. `null` when the runtime did not count the rows.
      - `rowCountExact` boolean, required: `false` when `rowCount` is the database's own estimate, used for large tables instead of counting every row.
      - `rows` object[], required

## Other responses

- `default`: Problem details (RFC 9457). Any 4xx/5xx response is one `application/problem+json` document.

---

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