YugabyteDB Universe database management API

The Universe database management API from YugabyteDB — 6 operation(s) for universe database management.

Operations 6

POST /api/v1/customers/{cUUID}/universes/{uniUUID}/create_db_credentials Create a database user for a universe #
POST /api/v1/customers/{cUUID}/universes/{uniUUID}/run_query Run a YSQL query in a universe #
POST /api/v1/customers/{cUUID}/universes/{uniUUID}/update_db_credentials Set a universe's database credentials #
POST /api/v1/customers/{cUUID}/universes/{univUUID}/configure/ycql Configure YCQL #
POST /api/v1/customers/{cUUID}/universes/{univUUID}/configure/ysql Configure YSQL #
POST /api/v1/customers/{cUUID}/universes/{uniUUID}/run_in_shell Run a shell command #

Documentation

Specifications

Other Resources

🔗
CLI
https://github.com/yugabyte/ybm-cli
🔗
Integrations
https://github.com/yugabyte/terraform-provider-ybm
🔗
TermsOfService
https://www.yugabyte.com/yugabytedb-managed-service-terms/
🔗
SDKs
https://github.com/yugabyte/platform-go-client
🔗
Integrations
https://github.com/yugabyte/terraform-provider-yba
🔗
Integrations
https://github.com/yugabyte/yugabyte-k8s-operator
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-ybuniverse.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-backup.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-backup-schedule.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-restore-job.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-storage-config.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-dr-config.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-pitr-config.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-release.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-support-bundle.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-ybcertificate.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-ybprovider.yaml
🔗
KubernetesCRD
https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/crd/yugabytedb-ybplatform.yaml

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/yugabytedb-universe-database-management-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

yugabytedb-universe-database-management-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: Yugabytedb Universe database management API
  version: v1
  contact:
    name: https://docs.yugabyte.com
  license:
    name: Polyform Free Trial License 1.0.0
    url: https://github.com/yugabyte/yugabyte-db/blob/master/licenses/POLYFORM-FREE-TRIAL-LICENSE-1.0.0.txt
  termsOfService: TODO(chirag)
  x-refined-note:
  - x-source differs across the merged source definitions and was not carried
  - x-split-from differs across the merged source definitions and was not carried
  description: 'Operations tagged Universe database management across 4 of this provider''s published API definitions: openapi_2.yaml, platform.swagger.json, yugabytedb-anywhere-v1-full.yaml, yugabytedb-anywhere-v1-universes.yaml. Each path carries the servers of the definition it was published in.'
servers:
- url: /
tags:
- name: Universe database management
paths:
  /api/v1/customers/{cUUID}/universes/{uniUUID}/create_db_credentials:
    post:
      description: YbaApi Internal.
      operationId: createUserInDB
      parameters:
      - in: path
        name: cUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: path
        name: uniUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: query
        name: request
        schema: {}
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DatabaseUserFormData'
        description: The database user to create
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/YBPSuccess'
          description: successful operation
      security:
      - apiKeyAuth: []
      summary: Create a database user for a universe
      tags:
      - Universe database management
      x-codegen-request-body-name: DatabaseUserFormData
    servers:
    - url: /
  /api/v1/customers/{cUUID}/universes/{uniUUID}/run_query:
    post:
      description: YbaApi Internal. Runs a YSQL query. Only valid when the platform is running in `OSS` mode.
      operationId: runYsqlQueryUniverse
      parameters:
      - in: path
        name: cUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: path
        name: uniUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: query
        name: request
        schema: {}
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/RunQueryFormData'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                type: object
          description: successful operation
      security:
      - apiKeyAuth: []
      summary: Run a YSQL query in a universe
      tags:
      - Universe database management
      x-codegen-request-body-name: RunQueryFormData
    servers:
    - url: /
  /api/v1/customers/{cUUID}/universes/{uniUUID}/update_db_credentials:
    post:
      description: YbaApi Internal.
      operationId: setDatabaseCredentials
      parameters:
      - in: path
        name: cUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: path
        name: uniUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: query
        name: request
        schema: {}
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DatabaseSecurityFormData'
        description: The database credentials
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/YBPSuccess'
          description: successful operation
      security:
      - apiKeyAuth: []
      summary: Set a universe's database credentials
      tags:
      - Universe database management
      x-codegen-request-body-name: DatabaseSecurityFormData
    servers:
    - url: /
  /api/v1/customers/{cUUID}/universes/{univUUID}/configure/ycql:
    post:
      description: 'WARNING: This is a preview API that could change. Queues a task to configure ycql in a universe.'
      operationId: configureYCQL
      parameters:
      - in: path
        name: cUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: path
        name: univUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: query
        name: request
        schema: {}
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ConfigureYCQLFormData'
        description: Configure YCQL Form Data
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/YBPTask'
          description: successful operation
      security:
      - apiKeyAuth: []
      summary: Configure YCQL
      tags:
      - Universe database management
      x-codegen-request-body-name: configure_ycql_form_data
    servers:
    - url: /
  /api/v1/customers/{cUUID}/universes/{univUUID}/configure/ysql:
    post:
      description: 'WARNING: This is a preview API that could change. Queues a task to configure ysql in a universe.'
      operationId: configureYSQL
      parameters:
      - in: path
        name: cUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: path
        name: univUUID
        required: true
        schema:
          format: uuid
          type: string
      - in: query
        name: request
        schema: {}
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ConfigureYSQLFormData'
        description: Configure YSQL Form Data
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/YBPTask'
          description: successful operation
      security:
      - apiKeyAuth: []
      summary: Configure YSQL
      tags:
      - Universe database management
      x-codegen-request-body-name: configure_ysql_form_data
    servers:
    - url: /
  /api/v1/customers/{cUUID}/universes/{uniUUID}/run_in_shell:
    post:
      description: This operation is no longer supported, for security reasons.
      operationId: runInShell
      parameters:
      - in: path
        name: cUUID
        required: true
        schema:
          type: string
          format: uuid
      - in: path
        name: uniUUID
        required: true
        schema:
          type: string
          format: uuid
      responses:
        '200':
          description: successful operation
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/YBPError'
      security:
      - apiKeyAuth: []
      summary: Run a shell command
      tags:
      - Universe database management
components:
  schemas:
    PerProcessFlags:
      example:
        value:
          key:
            key: value
      properties:
        value:
          additionalProperties:
            additionalProperties:
              type: string
            type: object
          type: object
      required:
      - value
      type: object
    YBPTask:
      example:
        taskUUID: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
        resourceUUID: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
      properties:
        resourceUUID:
          description: UUID of the resource being modified by the task
          format: uuid
          readOnly: true
          type: string
        taskUUID:
          description: Task UUID
          format: uuid
          readOnly: true
          type: string
      type: object
    RunQueryFormData:
      example:
        db_name: db_name
        query: query
        node_name: node_name
        table_type: YQL_TABLE_TYPE
      properties:
        db_name:
          type: string
        node_name:
          type: string
        query:
          type: string
        table_type:
          enum:
          - YQL_TABLE_TYPE
          - REDIS_TABLE_TYPE
          - PGSQL_TABLE_TYPE
          - TRANSACTION_STATUS_TABLE_TYPE
          type: string
      required:
      - db_name
      - node_name
      - query
      - table_type
      type: object
    CommunicationPorts:
      description: Communication ports
      example:
        nodeExporterPort: 5
        tserverHttpPort: 9
        internalYsqlServerRpcPort: 0
        ybControllerHttpPort: 2
        redisServerHttpPort: 2
        ybControllerrRpcPort: 4
        tserverRpcPort: 3
        ysqlServerHttpPort: 1
        yqlServerRpcPort: 1
        masterHttpPort: 6
        otelCollectorMetricsPort: 5
        ysqlServerRpcPort: 1
        yqlServerHttpPort: 7
        masterRpcPort: 1
        redisServerRpcPort: 7
      properties:
        internalYsqlServerRpcPort:
          description: Internal YSQL RPC port
          format: int32
          type: integer
        masterHttpPort:
          description: Master table HTTP port
          format: int32
          type: integer
        masterRpcPort:
          description: Master table RCP port
          format: int32
          type: integer
        nodeExporterPort:
          description: Node exporter port
          format: int32
          type: integer
        otelCollectorMetricsPort:
          description: Otel Collector metrics port
          format: int32
          type: integer
        redisServerHttpPort:
          description: Redis HTTP port
          format: int32
          type: integer
        redisServerRpcPort:
          description: Redis RPC port
          format: int32
          type: integer
        tserverHttpPort:
          description: Tablet server HTTP port
          format: int32
          type: integer
        tserverRpcPort:
          description: Tablet server RPC port
          format: int32
          type: integer
        ybControllerHttpPort:
          description: Yb controller HTTP port
          format: int32
          type: integer
        ybControllerrRpcPort:
          description: Yb controller RPC port
          format: int32
          type: integer
        yqlServerHttpPort:
          description: YQL HTTP port
          format: int32
          type: integer
        yqlServerRpcPort:
          description: YQL RPC port
          format: int32
          type: integer
        ysqlServerHttpPort:
          description: YSQL HTTP port
          format: int32
          type: integer
        ysqlServerRpcPort:
          description: YSQL RPC port
          format: int32
          type: integer
      type: object
    SpecificGFlags:
      description: GFlags for current cluster
      example:
        inheritFromPrimary: true
        perProcessFlags:
          value:
            key:
              key: value
        gflagGroups: '["ENHANCED_POSTGRES_COMPATIBILITY"]'
        perAZ:
          key:
            value:
              key:
                key: value
      properties:
        gflagGroups:
          description: YbaApi Internal. GFlag groups to be applied
          example: '["ENHANCED_POSTGRES_COMPATIBILITY"]'
          items:
            enum:
            - ENHANCED_POSTGRES_COMPATIBILITY
            type: string
          type: array
        inheritFromPrimary:
          type: boolean
        perAZ:
          additionalProperties:
            $ref: '#/components/schemas/PerProcessFlags'
          description: Overrides for gflags per availability zone
          type: object
        perProcessFlags:
          $ref: '#/components/schemas/PerProcessFlags'
      type: object
    ConfigureYCQLFormData:
      description: YCQL properties
      example:
        enableYCQL: true
        enableYCQLAuth: true
        ycqlPassword: ycqlPassword
        communicationPorts:
          nodeExporterPort: 5
          tserverHttpPort: 9
          internalYsqlServerRpcPort: 0
          ybControllerHttpPort: 2
          redisServerHttpPort: 2
          ybControllerrRpcPort: 4
          tserverRpcPort: 3
          ysqlServerHttpPort: 1
          yqlServerRpcPort: 1
          masterHttpPort: 6
          otelCollectorMetricsPort: 5
          ysqlServerRpcPort: 1
          yqlServerHttpPort: 7
          masterRpcPort: 1
          redisServerRpcPort: 7
      properties:
        communicationPorts:
          $ref: '#/components/schemas/CommunicationPorts'
        enableYCQL:
          description: Enable YCQL Api for the universe
          type: boolean
        enableYCQLAuth:
          description: Enable YCQL Auth for the universe
          type: boolean
        ycqlPassword:
          description: YCQL Auth password
          type: string
      type: object
    DatabaseSecurityFormData:
      description: Database security properties
      example:
        ycqlAdminUsername: ycqlAdminUsername
        ysqlAdminPassword: ysqlAdminPassword
        dbName: dbName
        ycqlAdminPassword: ycqlAdminPassword
        ycqlCurrAdminPassword: ycqlCurrAdminPassword
        ysqlCurrAdminPassword: ysqlCurrAdminPassword
        ysqlAdminUsername: ysqlAdminUsername
      properties:
        dbName:
          description: YSQL DB Name
          type: string
        ycqlAdminPassword:
          description: New YCQL admin password
          type: string
        ycqlAdminUsername:
          description: YCQL admin username
          type: string
        ycqlCurrAdminPassword:
          description: Current YCQL admin password
          type: string
        ysqlAdminPassword:
          description: New YSQL admin password
          type: string
        ysqlAdminUsername:
          description: YSQL admin username
          type: string
        ysqlCurrAdminPassword:
          description: Current YSQL admin password
          type: string
      type: object
    ConfigureYSQLFormData:
      description: YSQL properties
      example:
        ysqlPassword: ysqlPassword
        enableYSQL: true
        enableConnectionPooling: true
        enableYSQLAuth: true
        communicationPorts:
          nodeExporterPort: 5
          tserverHttpPort: 9
          internalYsqlServerRpcPort: 0
          ybControllerHttpPort: 2
          redisServerHttpPort: 2
          ybControllerrRpcPort: 4
          tserverRpcPort: 3
          ysqlServerHttpPort: 1
          yqlServerRpcPort: 1
          masterHttpPort: 6
          otelCollectorMetricsPort: 5
          ysqlServerRpcPort: 1
          yqlServerHttpPort: 7
          masterRpcPort: 1
          redisServerRpcPort: 7
        connectionPoolingGflags:
          key:
            inheritFromPrimary: true
            perProcessFlags:
              value:
                key:
                  key: value
            gflagGroups: '["ENHANCED_POSTGRES_COMPATIBILITY"]'
            perAZ:
              key:
                value:
                  key:
                    key: value
      properties:
        communicationPorts:
          $ref: '#/components/schemas/CommunicationPorts'
        connectionPoolingGflags:
          additionalProperties:
            $ref: '#/components/schemas/SpecificGFlags'
          description: YbaApi Internal. Extra Connection Pooling gflags for the universe. Only Supported for VMs and not yet k8s.
          type: object
        enableConnectionPooling:
          description: Enable Connection Pooling for the universe
          type: boolean
        enableYSQL:
          description: Enable YSQL Api for the universe
          type: boolean
        enableYSQLAuth:
          description: Enable YSQL Auth for the universe
          type: boolean
        ysqlPassword:
          description: YSQL Auth password
          type: string
      type: object
    YBPSuccess:
      example:
        success: true
        message: message
      properties:
        message:
          description: API response message.
          readOnly: true
          type: string
        success:
          description: API operation status. A value of true indicates the operation was successful.
          readOnly: true
          type: boolean
      type: object
    DatabaseUserFormData:
      example:
        password: password
        ycqlAdminUsername: ycqlAdminUsername
        dbRoleAttributes:
        - name: SUPERUSER
        - name: SUPERUSER
        ysqlAdminPassword: ysqlAdminPassword
        dbName: dbName
        ycqlAdminPassword: ycqlAdminPassword
        username: username
        ysqlAdminUsername: ysqlAdminUsername
      properties:
        dbName:
          type: string
        dbRoleAttributes:
          description: YbaApi Internal.
          items:
            $ref: '#/components/schemas/RoleAttribute'
          type: array
        password:
          type: string
        username:
          type: string
        ycqlAdminPassword:
          type: string
        ycqlAdminUsername:
          type: string
        ysqlAdminPassword:
          type: string
        ysqlAdminUsername:
          type: string
      required:
      - dbName
      - password
      - username
      - ycqlAdminPassword
      - ycqlAdminUsername
      - ysqlAdminPassword
      - ysqlAdminUsername
      type: object
    RoleAttribute:
      example:
        name: SUPERUSER
      properties:
        name:
          enum:
          - SUPERUSER
          - NOSUPERUSER
          - CREATEDB
          - NOCREATEDB
          - CREATEROLE
          - NOCREATEROLE
          - INHERIT
          - NOINHERIT
          - LOGIN
          - NOLOGIN
          - REPLICATION
          - NOREPLICATION
          - BYPASSRLS
          - NOBYPASSRLS
          type: string
      required:
      - name
      type: object
    YBPSuccess_2:
      properties:
        message:
          description: API response message.
          readOnly: true
          type: string
        success:
          description: API operation status. A value of true indicates the operation was successful.
          readOnly: true
          type: boolean
      type: object
    RunQueryFormData_2:
      properties:
        db_name:
          type: string
        query:
          type: string
        tableType:
          enum:
          - YQL_TABLE_TYPE
          - REDIS_TABLE_TYPE
          - PGSQL_TABLE_TYPE
          - TRANSACTION_STATUS_TABLE_TYPE
          type: string
      required:
      - db_name
      - query
      - tableType
      type: object
    YBPError:
      description: Generic error response from the YugabyteDB Anywhere API
      properties:
        error:
          description: User-visible unstructured error message
          example: There was a problem creating the universe
          type: string
        errorJson:
          description: User visible error message as json object
          example: '{ "foo" : "bar", "baz" : [1, 2, 3] }'
          type: object
        success:
          description: Always set to false to indicate failure
          example: false
          type: boolean
      type: object
    PerProcessFlags_2:
      example:
        value:
          key:
            key: value
      properties:
        value:
          additionalProperties:
            additionalProperties:
              type: string
            type: object
          type: object
          example: {}
      required:
      - value
      type: object
    YBPTask_2:
      example:
        taskUUID: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
        resourceUUID: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
      properties:
        resourceUUID:
          description: UUID of the resource being modified by the task
          format: uuid
          readOnly: true
          type: string
          example: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
        taskUUID:
          description: Task UUID
          format: uuid
          readOnly: true
          type: string
          example: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
      type: object
    RunQueryFormData_3:
      example:
        db_name: db_name
        query: query
        node_name: node_name
        table_type: YQL_TABLE_TYPE
      properties:
        db_name:
          type: string
          example: example-db_name
        node_name:
          type: string
          example: example-node_name
        query:
          type: string
          example: example-query
        table_type:
          enum:
          - YQL_TABLE_TYPE
          - REDIS_TABLE_TYPE
          - PGSQL_TABLE_TYPE
          - TRANSACTION_STATUS_TABLE_TYPE
          type: string
          example: YQL_TABLE_TYPE
      required:
      - db_name
      - node_name
      - query
      - table_type
      type: object
    CommunicationPorts_2:
      description: Communication ports
      example:
        nodeExporterPort: 5
        tserverHttpPort: 9
        internalYsqlServerRpcPort: 0
        ybControllerHttpPort: 2
        redisServerHttpPort: 2
        ybControllerrRpcPort: 4
        tserverRpcPort: 3
        ysqlServerHttpPort: 1
        yqlServerRpcPort: 1
        masterHttpPort: 6
        otelCollectorMetricsPort: 5
        ysqlServerRpcPort: 1
        yqlServerHttpPort: 7
        masterRpcPort: 1
        redisServerRpcPort: 7
      properties:
        internalYsqlServerRpcPort:
          description: Internal YSQL RPC port
          format: int32
          type: integer
          example: 5433
        masterHttpPort:
          description: Master table HTTP port
          format: int32
          type: integer
          example: 5433
        masterRpcPort:
          description: Master table RCP port
          format: int32
          type: integer
          example: 5433
        nodeExporterPort:
          description: Node exporter port
          format: int32
          type: integer
          example: 5433
        otelCollectorMetricsPort:
          description: Otel Collector metrics port
          format: int32
          type: integer
          example: 5433
        redisServerHttpPort:
          description: Redis HTTP port
          format: int32
          type: integer
          example: 5433
        redisServerRpcPort:
          description: Redis RPC port
          format: int32
          type: integer
          example: 5433
        tserverHttpPort:
          description: Tablet server HTTP port
          format: int32
          type: integer
          example: 5433
        tserverRpcPort:
          description: Tablet server RPC port
          format: int32
          type: integer
          example: 5433
        ybControllerHttpPort:
          description: Yb controller HTTP port
          format: int32
          type: integer
          example: 5433
        ybControllerrRpcPort:
          description: Yb controller RPC port
          format: int32
          type: integer
          example: 5433
        yqlServerHttpPort:
          description: YQL HTTP port
          format: int32
          type: integer
          example: 5433
        yqlServerRpcPort:
          description: YQL RPC port
          format: int32
          type: integer
          example: 5433
        ysqlServerHttpPort:
          description: YSQL HTTP port
          format: int32
          type: integer
          example: 5433
        ysqlServerRpcPort:
          description: YSQL RPC port
          format: int32
          type: integer
          example: 5433
      type: object
    SpecificGFlags_2:
      description: GFlags for current cluster
      example:
        inheritFromPrimary: true
        perProcessFlags:
          value:
            key:
              key: value
        gflagGroups: '["ENHANCED_POSTGRES_COMPATIBILITY"]'
        perAZ:
          key:
            value:
              key:
                key: value
      properties:
        gflagGroups:
          description: YbaApi Internal. GFlag groups to be applied
          example: '["ENHANCED_POSTGRES_COMPATIBILITY"]'
          items:
            enum:
            - ENHANCED_POSTGRES_COMPATIBILITY
            type: string
          type: array
        inheritFromPrimary:
          type: boolean
          example: true
        perAZ:
          additionalProperties:
            $ref: '#/components/schemas/PerProcessFlags_2'
          description: Overrides for gflags per availability zone
          type: object
          example: {}
        perProcessFlags:
          $ref: '#/components/schemas/PerProcessFlags_2'
      type: object
    ConfigureYCQLFormData_2:
      description: YCQL properties
      example:
        enableYCQL: true
        enableYCQLAuth: true
        ycqlPassword: ycqlPassword
        communicationPorts:
          nodeExporterPort: 5
          tserverHttpPort: 9
          internalYsqlServerRpcPort: 0
          ybControllerHttpPort: 2
          redisServerHttpPort: 2
          ybControllerrRpcPort: 4
          tserverRpcPort: 3
          ysqlServerHttpPort: 1
          yqlServerRpcPort: 1
          masterHttpPort: 6
          otelCollectorMetricsPort: 5
          ysqlServerRpcPort: 1
          yqlServerHttpPort: 7
          masterRpcPort: 1
          redisServerRpcPort: 7
      properties:
        communicationPorts:
          $ref: '#/components/schemas/CommunicationPorts_2'
        enableYCQL:
          description: Enable YCQL Api for the universe
          type: boolean
          example: true
        enableYCQLAuth:
          description: Enable YCQL Auth for the universe
          type: boolean
          example: true
        ycqlPassword:
          description: YCQL Auth password
          type: string
          example: REDACTED
      type: object
    DatabaseSecurityFormData_2:
      description: Database security properties
      example:
        ycqlAdminUsername: ycqlAdminUsername
        ysqlAdminPassword: ysqlAdminPassword
        dbName: dbName
        ycqlAdminPassword: ycqlAdminPassword
        ycqlCurrAdminPassword: ycqlCurrAdminPassword
        ysqlCurrAdminPassword: ysqlCurrAdminPassword
        ysqlAdminUsername: ysqlAdminUsername
      properties:
        dbName:
          description: YSQL DB Name
          type: string
          example: example-dbName
        ycqlAdminPassword:
          description: New YCQL admin password
          type: string
          example: REDACTED
        ycqlAdminUsername:
          description: YCQL admin username
          type: string
          example: example-ycqlAdminUsername
        ycqlCurrAdminPassword:
          description: Current YCQL admin password
          type: string
          example: REDACTED
        ysqlAdminPassword:
          description: New YSQL admin password
          type: string
          example: REDACTED
        ysqlAdminUsername:
          description: YSQL admin username
          type: string
          example: example-ysqlAdminUsername
        ysqlCurrAdminPassword:
          description: Current YSQL admin password
          type: string
          example: REDACTED
      type: object
    ConfigureYSQLFormData_2:
      description: YSQL properties
      example:
        ysqlPassword: ysqlPassword
        enableYSQL: true
        enableConnectionPooling: true
        enableYSQLAuth: true
        communicationPorts:
          nodeExporterPort: 5
          tserverHttpPort: 9
          internalYsqlServerRpcPort: 0
          ybControllerHttpPort: 2
          redisServerHttpPort: 2
          ybControllerrRpcPort: 4
          tserverRpcPort: 3
          ysqlServerHttpPort: 1
          yqlServerRpcPort: 1
          masterHttpPort: 6
          otelCollectorMetricsPort: 5
          ysqlServerRpcPort: 1
          yqlServerHttpPort: 7
          masterRpcPort: 1
          redisServerRpcPort: 7
        connectionPoolingGflags:
          key:
            inheritFromPrimary: true
            perProcessFlags:
              value:
                key:
                  key: value
            gflagGroups: '["ENHANCED_POSTGRES_COMPATIBILITY"]'
            perAZ:
              key:
                value:
                  key:
                    key: value
      properties:
        communicationPorts:
          $ref: '#/components/schemas/CommunicationPorts_2'
        connectionPoolingGflags:
          additionalProperties:
            $ref: '#/components/schemas/SpecificGFlags_2'
          description: YbaApi Internal. Extra Connection Pooling gflags for the universe. Only Supported for VMs and not yet k8s.
          type: object
          example: {}
        enableConnectionPooling:
          description: Enable Connection Pooling for the universe
          type: boolean
          example: true
        enableYSQL:
          description: Enable YSQL Api for the universe
          type: boolean
          example: true
        enableYSQLAuth:
          description: Enable YSQL Auth for the universe
          type: boolean
          example: true
        ysqlPassword:
          description: YSQL Auth password
          type: string
          example: REDACTED
      type: object
    YBPSuccess_3:
      example:
        success: true
        message: message
      properties:
        message:
          description: API response message.
          readOnly: true
          type: string
          example: Example message
        success:
          description: API operation status. A value of true indicates the operation was successful.
          readOnly: true
          type: boolean
          example: true
      type: object
    DatabaseUserFormData_2:
      example:
        password: password
        ycqlAdminUsername: ycqlAdminUsername
        dbRoleAttributes:
        - name: SUPERUSER
        - name: SUPERUSER
        ysqlAdminPassword: ysqlAdminPassword
        dbName: dbName
        ycqlAdminPassword: ycqlAdminPassword
        username: username
        ysqlAdminUsername: ysqlAdminUsername
      properties:
        dbName:
          type: string
          example: example-dbName
        dbRoleAttributes:
          description: YbaApi Internal.
          items:
            $ref: '#/components/schemas/RoleAttribute_2'
          type: array
          example:
          - name: SUPERUSER
        password:
          type: string
          example: REDACTED
        username:
          type: string
          example: example-username
        ycqlAdminPassword:
          type: string
          example: REDACTED
        ycqlAdminUsername:
          type: string
          example: example-ycqlAdminUsername
        ysqlAdminPassword:
          type: string
          example: REDACTED
        ysqlAdminUsername:
          type: string
          example: example-ysqlAdminUsername
      required:
      - dbName
      - password
      - username
      - ycqlAdminPassword
      - ycqlAdminUsername
      - ysqlAdminPassword
      - ysqlAdminUsername
      type: object
    RoleAttribute_2:
      example:
        name: SUPERUSER
      properties:
        name:
          enum:
          - SUPERUSER
          - NOSUPERUSER
          - CREATEDB
          - NOCREATEDB
          - CREATEROLE
          - NOCREATEROLE
          - INHERIT
          - NOINHERIT
          - LOGIN
          - NOLOGIN
          - REPLICATION
          - NOREPLICATION
          - BYPASSRLS
          - NOBYPASSRLS
          type: string
          example: SUPERUSER
      required:
      - name
      type: object
    PerProcessFlags_3:
      example:
        value:
          key:
            key: value
      properties:
        value:
          additionalProperties:
            additionalProperties:
              type: string
            type: object
          type: object
          example: {}
      required:
      - value
      type: object
    YBPTask_3:
      example:
        taskUUID: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
        resourceUUID: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
      properties:
        resourceUUID:
          description: UUID of the resource being modified by the task
          format: uuid
          readOnly: true
          type: string
          example: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
        taskUUID:
          description: Task UUID
          format: uuid
          readOnly: true
          type: string
          example: 046b6c7f-0b8a-43b9-b35d-6489e6daee91
      type: object
    RunQueryFormData_4:
      example:
        db_name: db_name
        query: query
        node_name: node_name
        table_type: YQL_TABLE_TYPE
      properties:
        db_name:
          type: string
          example: example-db_name
        node_name:
          type:

# --- truncated at 32 KB (43 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/yugabytedb/refs/heads/main/openapi/yugabytedb-universe-database-management-api-openapi.yml