Fermyon

Fermyon sql-databases API

The sql-databases API from Fermyon — 5 operation(s) for sql-databases.

GitHub OpenAPI

Operations 7

POST /api/sql-databases/create
POST /api/sql-databases/execute
DELETE /api/sql-databases
GET /api/sql-databases
POST /api/sql-databases/{database}/links
DELETE /api/sql-databases/{database}/links
PATCH /api/sql-databases/{database}/rename

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/fermyon/refs/heads/main/openapi/fermyon-sql-databases-api-openapi.yml

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/fermyon-sql-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

fermyon-sql-databases-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Fermyon Cloud accounts Sql Databases API
  version: '1.0'
  description: OpenAPI 3.1 specification for the Fermyon Cloud REST API, derived from the public swagger.json published in the fermyon/cloud-openapi repository on GitHub.
servers:
- url: https://cloud.fermyon.com
  description: Fermyon Cloud production API
security:
- Bearer: []
tags:
- name: sql-databases
paths:
  /api/sql-databases/create:
    post:
      tags:
      - sql-databases
      parameters:
      - name: Api-Version
        in: header
        description: The requested API version
        schema:
          type: string
          default: '1.0'
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/CreateSqlDatabaseCommand'
          application/json:
            schema:
              $ref: '#/components/schemas/CreateSqlDatabaseCommand'
          text/json:
            schema:
              $ref: '#/components/schemas/CreateSqlDatabaseCommand'
          application/*+json:
            schema:
              $ref: '#/components/schemas/CreateSqlDatabaseCommand'
        required: true
      responses:
        '200':
          description: Success
  /api/sql-databases/execute:
    post:
      tags:
      - sql-databases
      parameters:
      - name: Api-Version
        in: header
        description: The requested API version
        schema:
          type: string
          default: '1.0'
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/ExecuteSqlStatementCommand'
          application/json:
            schema:
              $ref: '#/components/schemas/ExecuteSqlStatementCommand'
          text/json:
            schema:
              $ref: '#/components/schemas/ExecuteSqlStatementCommand'
          application/*+json:
            schema:
              $ref: '#/components/schemas/ExecuteSqlStatementCommand'
        required: true
      responses:
        '200':
          description: Success
  /api/sql-databases:
    delete:
      tags:
      - sql-databases
      parameters:
      - name: Api-Version
        in: header
        description: The requested API version
        schema:
          type: string
          default: '1.0'
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/DeleteSqlDatabaseCommand'
          application/json:
            schema:
              $ref: '#/components/schemas/DeleteSqlDatabaseCommand'
          text/json:
            schema:
              $ref: '#/components/schemas/DeleteSqlDatabaseCommand'
          application/*+json:
            schema:
              $ref: '#/components/schemas/DeleteSqlDatabaseCommand'
        required: true
      responses:
        '200':
          description: Success
    get:
      tags:
      - sql-databases
      parameters:
      - name: appId
        in: query
        schema:
          type: string
          format: uuid
      - name: Api-Version
        in: header
        description: The requested API version
        schema:
          type: string
          default: '1.0'
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/GetSqlDatabasesQuery'
          application/json:
            schema:
              $ref: '#/components/schemas/GetSqlDatabasesQuery'
          text/json:
            schema:
              $ref: '#/components/schemas/GetSqlDatabasesQuery'
          application/*+json:
            schema:
              $ref: '#/components/schemas/GetSqlDatabasesQuery'
      responses:
        '200':
          description: Success
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/DatabasesList'
            application/json:
              schema:
                $ref: '#/components/schemas/DatabasesList'
            text/json:
              schema:
                $ref: '#/components/schemas/DatabasesList'
  /api/sql-databases/{database}/links:
    post:
      tags:
      - sql-databases
      parameters:
      - name: database
        in: path
        required: true
        schema:
          type: string
      - name: Api-Version
        in: header
        description: The requested API version
        schema:
          type: string
          default: '1.0'
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/ResourceLabel'
          application/json:
            schema:
              $ref: '#/components/schemas/ResourceLabel'
          text/json:
            schema:
              $ref: '#/components/schemas/ResourceLabel'
          application/*+json:
            schema:
              $ref: '#/components/schemas/ResourceLabel'
        required: true
      responses:
        '200':
          description: Success
    delete:
      tags:
      - sql-databases
      parameters:
      - name: database
        in: path
        required: true
        schema:
          type: string
      - name: Api-Version
        in: header
        description: The requested API version
        schema:
          type: string
          default: '1.0'
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/ResourceLabel'
          application/json:
            schema:
              $ref: '#/components/schemas/ResourceLabel'
          text/json:
            schema:
              $ref: '#/components/schemas/ResourceLabel'
          application/*+json:
            schema:
              $ref: '#/components/schemas/ResourceLabel'
        required: true
      responses:
        '200':
          description: Success
  /api/sql-databases/{database}/rename:
    patch:
      tags:
      - sql-databases
      parameters:
      - name: database
        in: path
        required: true
        schema:
          type: string
      - name: Api-Version
        in: header
        description: The requested API version
        schema:
          type: string
          default: '1.0'
      requestBody:
        content:
          application/json-patch+json:
            schema:
              type: string
          application/json:
            schema:
              type: string
          text/json:
            schema:
              type: string
          application/*+json:
            schema:
              type: string
        required: true
      responses:
        '200':
          description: Success
components:
  schemas:
    Database:
      required:
      - links
      - name
      type: object
      properties:
        name:
          minLength: 1
          type: string
        default:
          type: boolean
        links:
          type: array
          items:
            $ref: '#/components/schemas/ResourceLabel'
      additionalProperties: false
    ExecuteSqlStatementCommand:
      required:
      - database
      - default
      - statement
      type: object
      properties:
        database:
          minLength: 1
          type: string
        default:
          type: boolean
        statement:
          minLength: 1
          type: string
      additionalProperties: false
    DeleteSqlDatabaseCommand:
      required:
      - name
      type: object
      properties:
        name:
          minLength: 1
          type: string
      additionalProperties: false
    ResourceLabel:
      required:
      - appId
      - label
      type: object
      properties:
        label:
          minLength: 1
          type: string
        appId:
          type: string
          format: uuid
        appName:
          type: string
      additionalProperties: false
    GetSqlDatabasesQuery:
      type: object
      properties:
        appId:
          type: string
          format: uuid
          nullable: true
      additionalProperties: false
    DatabasesList:
      required:
      - databases
      type: object
      properties:
        databases:
          type: array
          items:
            $ref: '#/components/schemas/Database'
      additionalProperties: false
    CreateSqlDatabaseCommand:
      required:
      - name
      type: object
      properties:
        name:
          minLength: 1
          type: string
        appId:
          type: string
          format: uuid
          nullable: true
        label:
          type: string
          nullable: true
      additionalProperties: false
  securitySchemes:
    Bearer:
      type: apiKey
      description: 'JWT Authorization header using the Bearer scheme. Example: "Authorization: Bearer {token}"'
      name: Authorization
      in: header