Grapes Knowledge Base

Grapes Knowledge Base Databases API

The Databases API from Grapes Knowledge Base — 4 operation(s) for databases.

GitHub OpenAPI

Operations 8

GET /api/{version}/organizations/{orgId}/projects/{projId}/databases Get databases #
POST /api/{version}/organizations/{orgId}/projects/{projId}/databases Create database #
GET /api/{version}/organizations/{orgId}/projects/{projId}/databases/{id} Get database by id #
PUT /api/{version}/organizations/{orgId}/projects/{projId}/databases/{id} Update database #
DELETE /api/{version}/organizations/{orgId}/projects/{projId}/databases/{id} Delete database #
POST /api/{version}/organizations/{orgId}/projects/{projId}/databases/{id}/schema/extract Extract database schema #
GET /api/{version}/organizations/{orgId}/projects/{projId}/databases/{id}/schema Get database schema #
POST /api/{version}/organizations/{orgId}/projects/{projId}/databases/{id}/schema Create database schema #

Documentation

📖
Documentation
https://docs.data-grapes.com/en/docs/developer-docs/api/api-reference/

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/grapes-knowledge-base/refs/heads/main/openapi/grapes-knowledge-base-databases-api-openapi.yml

Other Resources

🔗
Security
https://docs.data-grapes.com/en/docs/developer-docs/api/api-security/

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/grapes-knowledge-base:grapes-knowledge-base-databases-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.

GitHub Google LinkedIn

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

OpenAPI Specification

grapes-knowledge-base-databases-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Grapes Databases API
  version: v1
security:
- Bearer: []
tags:
- name: Databases
paths:
  /api/{version}/organizations/{orgId}/projects/{projId}/databases:
    get:
      tags:
      - Databases
      operationId: GetDatabases
      parameters:
      - name: orgId
        in: path
        required: true
        schema:
          type: string
      - name: projId
        in: path
        required: true
        schema:
          type: string
      - name: searchQuery
        in: query
        schema:
          type: string
      - name: Skip
        in: query
        schema:
          type: integer
          format: int32
      - name: Take
        in: query
        schema:
          type: integer
          format: int32
      - name: version
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/DatabaseDtoListItemResponse'
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseDtoListItemResponse'
            text/json:
              schema:
                $ref: '#/components/schemas/DatabaseDtoListItemResponse'
      summary: Get databases
      x-summary-source: derived
    post:
      tags:
      - Databases
      operationId: CreateDatabase
      parameters:
      - name: orgId
        in: path
        required: true
        schema:
          type: string
      - name: projId
        in: path
        required: true
        schema:
          type: string
      - name: version
        in: path
        required: true
        schema:
          type: string
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/CreateDatabaseRequest'
          text/json:
            schema:
              $ref: '#/components/schemas/CreateDatabaseRequest'
          application/*+json:
            schema:
              $ref: '#/components/schemas/CreateDatabaseRequest'
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/DatabaseDtoItemResponse'
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseDtoItemResponse'
            text/json:
              schema:
                $ref: '#/components/schemas/DatabaseDtoItemResponse'
        '400':
          description: Validation failed
      summary: Create database
      x-summary-source: derived
  /api/{version}/organizations/{orgId}/projects/{projId}/databases/{id}:
    get:
      tags:
      - Databases
      operationId: GetDatabaseById
      parameters:
      - name: orgId
        in: path
        required: true
        schema:
          type: string
      - name: projId
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
      - name: version
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/DatabaseDtoItemResponse'
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseDtoItemResponse'
            text/json:
              schema:
                $ref: '#/components/schemas/DatabaseDtoItemResponse'
        '404':
          description: Database not found
      summary: Get database by id
      x-summary-source: derived
    put:
      tags:
      - Databases
      operationId: UpdateDatabase
      parameters:
      - name: orgId
        in: path
        required: true
        schema:
          type: string
      - name: projId
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
      - name: version
        in: path
        required: true
        schema:
          type: string
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/UpdateDatabaseRequest'
          text/json:
            schema:
              $ref: '#/components/schemas/UpdateDatabaseRequest'
          application/*+json:
            schema:
              $ref: '#/components/schemas/UpdateDatabaseRequest'
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/DatabaseDtoItemResponse'
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseDtoItemResponse'
            text/json:
              schema:
                $ref: '#/components/schemas/DatabaseDtoItemResponse'
        '400':
          description: Validation failed
        '404':
          description: Database not found
      summary: Update database
      x-summary-source: derived
    delete:
      tags:
      - Databases
      operationId: DeleteDatabase
      parameters:
      - name: orgId
        in: path
        required: true
        schema:
          type: string
      - name: projId
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
      - name: version
        in: path
        required: true
        schema:
          type: string
      responses:
        '400':
          description: Validation failed
        '404':
          description: Database not found
      summary: Delete database
      x-summary-source: derived
  /api/{version}/organizations/{orgId}/projects/{projId}/databases/{id}/schema/extract:
    post:
      tags:
      - Databases
      operationId: ExtractDatabaseSchema
      parameters:
      - name: orgId
        in: path
        required: true
        schema:
          type: string
      - name: projId
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
      - name: version
        in: path
        required: true
        schema:
          type: string
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ExtractSchemaRequest'
          text/json:
            schema:
              $ref: '#/components/schemas/ExtractSchemaRequest'
          application/*+json:
            schema:
              $ref: '#/components/schemas/ExtractSchemaRequest'
      responses:
        '202':
          description: Accepted
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/IActionResult'
            application/json:
              schema:
                $ref: '#/components/schemas/IActionResult'
            text/json:
              schema:
                $ref: '#/components/schemas/IActionResult'
        '400':
          description: Validation failed
        '404':
          description: Database not found
      summary: Extract database schema
      x-summary-source: derived
  /api/{version}/organizations/{orgId}/projects/{projId}/databases/{id}/schema:
    get:
      tags:
      - Databases
      operationId: GetDatabaseSchema
      parameters:
      - name: orgId
        in: path
        required: true
        schema:
          type: string
      - name: projId
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
      - name: version
        in: path
        required: true
        schema:
          type: string
      responses:
        '202':
          description: Accepted
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SchemaDtoItemResponse'
            application/json:
              schema:
                $ref: '#/components/schemas/SchemaDtoItemResponse'
            text/json:
              schema:
                $ref: '#/components/schemas/SchemaDtoItemResponse'
        '400':
          description: Validation failed
        '404':
          description: Schema not found
      summary: Get database schema
      x-summary-source: derived
    post:
      tags:
      - Databases
      operationId: CreateDatabaseSchema
      parameters:
      - name: orgId
        in: path
        required: true
        schema:
          type: string
      - name: projId
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
      - name: version
        in: path
        required: true
        schema:
          type: string
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/UpdateSchemaRequest'
          text/json:
            schema:
              $ref: '#/components/schemas/UpdateSchemaRequest'
          application/*+json:
            schema:
              $ref: '#/components/schemas/UpdateSchemaRequest'
      responses:
        '202':
          description: Accepted
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SchemaDtoItemResponse'
            application/json:
              schema:
                $ref: '#/components/schemas/SchemaDtoItemResponse'
            text/json:
              schema:
                $ref: '#/components/schemas/SchemaDtoItemResponse'
        '400':
          description: Validation failed
      summary: Create database schema
      x-summary-source: derived
components:
  schemas:
    RelationDto:
      type: object
      properties:
        name:
          type:
          - string
          - 'null'
        fromTable:
          type:
          - string
          - 'null'
        toTable:
          type:
          - string
          - 'null'
        columnMappings:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/RelationColumnMappingDto'
      additionalProperties: false
    DatabaseEnvironmentRequest:
      type: object
      properties:
        environmentId:
          type:
          - string
          - 'null'
        infrastructureId:
          type:
          - string
          - 'null'
      additionalProperties: false
    UpdateSchemaRequest:
      type: object
      properties:
        tables:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/TableDto'
        relations:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/RelationDto'
        uniqueIndexes:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/UniqueIndexDto'
      additionalProperties: false
    DatabaseDto:
      type: object
      properties:
        id:
          type:
          - string
          - 'null'
        name:
          type:
          - string
          - 'null'
        type:
          $ref: '#/components/schemas/DataBaseTypes'
        environments:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/DatabaseEnvironmentDto'
      additionalProperties: false
    DatabaseDtoItemResponse:
      type: object
      properties:
        item:
          $ref: '#/components/schemas/DatabaseDto'
        links:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/HateoasLink'
      additionalProperties: false
    DatabaseEnvironmentDto:
      type: object
      properties:
        environmentId:
          type:
          - string
          - 'null'
        infrastructureId:
          type:
          - string
          - 'null'
      additionalProperties: false
    FieldDto:
      type: object
      properties:
        name:
          type:
          - string
          - 'null'
        dataType:
          type:
          - string
          - 'null'
        innerDataType:
          type:
          - string
          - 'null'
        dataTypeGroup:
          $ref: '#/components/schemas/DataTypeGroup'
        nullable:
          type: boolean
        isAutoGenerated:
          type: boolean
        isComputed:
          type: boolean
        isPrimaryKey:
          type: boolean
      additionalProperties: false
    ExtractSchemaRequest:
      type: object
      properties:
        databaseEnvironmentId:
          type:
          - string
          - 'null'
      additionalProperties: false
    IActionResult:
      type: object
      additionalProperties: false
    SchemaDto:
      type: object
      properties:
        tables:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/TableDto'
        relations:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/RelationDto'
        uniqueIndexes:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/UniqueIndexDto'
      additionalProperties: false
    HateoasLink:
      type: object
      properties:
        relation:
          type:
          - string
          - 'null'
        uri:
          type:
          - string
          - 'null'
        method:
          type:
          - string
          - 'null'
      additionalProperties: false
    UniqueIndexColumnDto:
      type: object
      properties:
        ordinal:
          type: integer
          format: int32
        name:
          type:
          - string
          - 'null'
      additionalProperties: false
    SchemaDtoItemResponse:
      type: object
      properties:
        item:
          $ref: '#/components/schemas/SchemaDto'
        links:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/HateoasLink'
      additionalProperties: false
    RelationColumnMappingDto:
      type: object
      properties:
        fromColumn:
          type:
          - string
          - 'null'
        toColumn:
          type:
          - string
          - 'null'
      additionalProperties: false
    DatabaseDtoListItemResponse:
      type: object
      properties:
        items:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/DatabaseDtoItemResponse'
        totalCount:
          type: integer
          format: int32
      additionalProperties: false
    DataBaseTypes:
      enum:
      - SqlServer
      - MySql
      type: string
    UpdateDatabaseRequest:
      type: object
      properties:
        name:
          type:
          - string
          - 'null'
        type:
          $ref: '#/components/schemas/DataBaseTypes'
        environments:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/DatabaseEnvironmentRequest'
      additionalProperties: false
    UniqueIndexDto:
      type: object
      properties:
        table:
          type:
          - string
          - 'null'
        indexName:
          type:
          - string
          - 'null'
        columns:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/UniqueIndexColumnDto'
      additionalProperties: false
    TableDto:
      type: object
      properties:
        name:
          type:
          - string
          - 'null'
        fields:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/FieldDto'
      additionalProperties: false
    DataTypeGroup:
      enum:
      - String
      - Number
      - Boolean
      - Date
      - Binary
      - Unknown
      type: string
    CreateDatabaseRequest:
      type: object
      properties:
        name:
          type:
          - string
          - 'null'
        type:
          $ref: '#/components/schemas/DataBaseTypes'
        environments:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/DatabaseEnvironmentRequest'
      additionalProperties: false
  securitySchemes:
    Bearer:
      type: oauth2
      description: "JWT Authorization header using the Bearer scheme. \n\n Enter 'Bearer' [space] and then your token in the text input below.\n\nExample: \"Bearer 1safsfsdfdfd\""
x-provenance:
  method: harvested
  publisher: Grapes Knowledge Base
  source: https://api.data-grapes.com/swagger/v1/swagger.json
  note: split by refine-openapis from the provider's own published document, verified by fetch (openapi/_original/*.fetch.json);
    stamped by stamp-openapi-provenance.py (roadmap#793)