---
title: "Save a query"
method: PUT
path: "/api/v1/databases/{database_id}/saved-queries"
tags: ["Managed Databases"]
---

# Save a query

`PUT /api/v1/databases/{database_id}/saved-queries`

## Request

- Base URL: `https://api.rafftechnologies.com`
- URL: `https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries`
- Auth: API key in header `X-API-Key`

Save a query under a name, shared by everyone on the account. Saving again with the same name replaces it. Name up to 80 characters, statement up to 20,000 characters, up to 100 saved queries per database.

## Path parameters

- `database_id` string, required

## Request body

- object
  - `name` string, required
  - `statement` string, required

## Response `200`

Saved query

- object
  - `success` boolean
  - `query` DatabaseSavedQuery
    - `name` string
    - `statement` string
    - `created_by` string
    - `updated_at` string, date-time

## Other responses

- `400`: Invalid request parameters
- `401`: Authentication required
- `404`: Resource not found

## Changes

- **2026-10-05** `26292956c4b3`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/rafftechnologies/apis/raff-api/changes/api/v1/databases/:database_id/saved-queries/put.md)

---

[API](https://skmtc.dev/rafftechnologies/apis/raff-api.md) - [All operations](https://skmtc.dev/rafftechnologies/apis/raff-api/llms.txt) - [OpenAPI document](https://skmtc.dev/rafftechnologies/apis/raff-api/revisions/3d30cde0acb4?raw)