> ## Documentation Index
> Fetch the complete documentation index at: https://docs.korve.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Query Database

> Query bounded database compute, storage, connection, pool, and query-throughput series.



## OpenAPI

````yaml /openapi.json post /v1/orgs/{orgId}/projects/{projectId}/databases/{databaseId}/metrics/query
openapi: 3.1.0
info:
  title: Korve API
  version: 0.1.0
  description: >-
    Typed control plane for deploying applications and explicitly provisioning
    their managed infrastructure.
servers:
  - url: https://api.korve.dev
security: []
paths:
  /v1/orgs/{orgId}/projects/{projectId}/databases/{databaseId}/metrics/query:
    post:
      tags:
        - metrics
      summary: Query Database
      description: >-
        Query bounded database compute, storage, connection, pool, and
        query-throughput series.
      operationId: metrics.queryDatabase
      parameters:
        - name: orgId
          in: path
          required: true
          schema:
            type: string
          description: The organization's id (UUID) or slug — either form is accepted.
        - name: projectId
          in: path
          required: true
          schema:
            type: string
          description: The project's id (UUID) or slug — either form is accepted.
        - name: databaseId
          in: path
          required: true
          schema:
            type: string
      requestBody:
        required: true
        x-korve-max-bytes: 1048576
        content:
          application/json:
            schema:
              type: object
              properties:
                names:
                  type: array
                  items:
                    type: string
                    enum:
                      - cpu.percent
                      - memory.used_bytes
                      - memory.limit_bytes
                      - disk.used_bytes
                      - disk.limit_bytes
                      - disk.read_iops
                      - disk.write_iops
                      - network.receive_bytes
                      - network.transmit_bytes
                      - runtime.restarts
                      - runtime.uptime_seconds
                      - http.requests
                      - http.errors
                      - database.connections
                      - database.pool_waiting
                      - database.queries_per_second
                      - database.query_latency_avg_ms
                      - database.query_latency_p50_ms
                      - database.query_latency_p90_ms
                      - database.query_latency_p95_ms
                      - database.query_latency_p99_ms
                      - queue.backlog_messages
                      - queue.oldest_message_age_seconds
                      - cron.failures
                  minItems: 1
                  maxItems: 10
                  description: One to 10 metric names.
                from:
                  type: string
                  format: date-time
                until:
                  type: string
                  format: date-time
                stepSeconds:
                  type: integer
                  description: >-
                    Bucket width. Raw one-minute data is retained for 30 days;
                    hourly aggregates for 13 months.
                aggregation:
                  type: string
                  enum:
                    - avg
                    - min
                    - max
                    - sum
                    - p50
                    - p95
                    - p99
                groupBy:
                  type: array
                  items:
                    type: string
                    enum:
                      - instance
                      - process
                      - route
                      - status
                      - queue
                      - cron
              required:
                - names
                - from
                - until
              additionalProperties: false
      responses:
        '200':
          description: Database metric series in ascending timestamp order.
          content:
            application/json:
              schema:
                type: object
                properties:
                  from:
                    type: string
                    format: date-time
                  until:
                    type: string
                    format: date-time
                  stepSeconds:
                    type: integer
                  series:
                    type: array
                    items:
                      type: object
                      properties:
                        name:
                          type: string
                          enum:
                            - cpu.percent
                            - memory.used_bytes
                            - memory.limit_bytes
                            - disk.used_bytes
                            - disk.limit_bytes
                            - disk.read_iops
                            - disk.write_iops
                            - network.receive_bytes
                            - network.transmit_bytes
                            - runtime.restarts
                            - runtime.uptime_seconds
                            - http.requests
                            - http.errors
                            - database.connections
                            - database.pool_waiting
                            - database.queries_per_second
                            - database.query_latency_avg_ms
                            - database.query_latency_p50_ms
                            - database.query_latency_p90_ms
                            - database.query_latency_p95_ms
                            - database.query_latency_p99_ms
                            - queue.backlog_messages
                            - queue.oldest_message_age_seconds
                            - cron.failures
                        unit:
                          type: string
                        labels:
                          type: object
                          additionalProperties:
                            type: string
                        points:
                          type: array
                          items:
                            type: object
                            properties:
                              timestamp:
                                type: string
                                format: date-time
                              value:
                                type:
                                  - number
                                  - 'null'
                            required:
                              - timestamp
                              - value
                      required:
                        - name
                        - unit
                        - labels
                        - points
                required:
                  - from
                  - until
                  - stepSeconds
                  - series
        '404':
          description: No such database in this project.
        '422':
          description: >-
            Invalid database metric, time window, step, aggregation, or
            grouping.
        '429':
          description: Metrics query limit reached.
      security:
        - apiKey: []
        - session: []
components:
  securitySchemes:
    apiKey:
      type: http
      scheme: bearer
      bearerFormat: korve_api_key
    session:
      type: apiKey
      in: cookie
      name: korve.session_token

````