Optilogic

Optilogic Storage API

Get storage information

Documentation GitHub OpenAPI

Operations 10

GET /storages/db-connection-strings Get the connection information for all SQL storage items #

GET /storage/{storageName}/connection-string Get the connection information for a SQL storage item #

GET /storage/{storageName}/db-objects Get database objects (stats, tables, and views) for a SQL storage item #

GET /storage/{storageName}/schema Get database schema (tables and views) for a SQL storage item #

GET /storage/{storageName}/tables Get tables information for a SQL storage item #

POST /storage/{storageName}/empty-tables Delete all data rows from specified tables in a SQL storage item #

POST /storage/{storageName}/db-data-export Export all rows from selected tables/views, or the results of a query in a SQL… #

PUT /storage/{storageName}/file/move Move a file within a storage device #

PUT /storage/{storageName}/folder/move Move a folder within a storage device #

PUT /storage/{storageName}/folder/copy Copy a folder within a storage device or from one storage device to another #

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/optilogic-storage-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

openapi: 3.2.0
info:
  description: All Optilogic users can view the endpoint documentation below, upgrade to a paid account to gain access.
  version: 1.0.0
  title: Optilogic REST Storage API
  contact:
    name: Optilogic Support
    email: support@optilogic.com
servers:
- url: https://api.optilogic.app/v0
tags:
- name: Storage
  description: Get storage information
paths:
  /storages/db-connection-strings:
    get:
      tags:
      - Storage
      summary: Get the connection information for all SQL storage items
      description: ''
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/StoragesDBConnectionStrings'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      operationId: getStoragesDbConnectionStrings
      x-operation-id-source: derived
  /storage/{storageName}/connection-string:
    get:
      tags:
      - Storage
      summary: Get the connection information for a SQL storage item
      description: ''
      parameters:
      - name: storageName
        in: path
        description: Name of the target storage device
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/StorageSqlConnection'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      operationId: getStorageByStorageNameConnectionString
      x-operation-id-source: derived
  /storage/{storageName}/db-objects:
    get:
      tags:
      - Storage
      summary: Get database objects (stats, tables, and views) for a SQL storage item
      description: ''
      parameters:
      - name: storageName
        in: path
        description: Name of the target storage device
        required: true
        schema:
          type: string
      - name: type
        in: query
        description: Type of database object to return
        required: false
        schema:
          type: string
          enum:
          - stats
          - tables
          - views
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetDbObjects'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      operationId: getStorageByStorageNameDbObjects
      x-operation-id-source: derived
  /storage/{storageName}/schema:
    get:
      tags:
      - Storage
      summary: Get database schema (tables and views) for a SQL storage item
      description: ''
      parameters:
      - name: storageName
        in: path
        description: Name of the target storage device
        required: true
        schema:
          type: string
      - name: schema
        in: query
        description: Name of the database schema. (Blank or missing for all schemas)
        required: false
        schema:
          type: string
      - name: table
        in: query
        description: Name of the database table. (Blank or missing for all tables)
        required: false
        schema:
          type: string
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetSchema'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      operationId: getStorageByStorageNameSchema
      x-operation-id-source: derived
  /storage/{storageName}/tables:
    get:
      tags:
      - Storage
      summary: Get tables information for a SQL storage item
      description: ''
      parameters:
      - name: storageName
        in: path
        description: Name of the target storage device
        required: true
        schema:
          type: string
      - name: schema
        in: query
        description: Database schema to return tables from
        required: false
        schema:
          type: string
          default: ''
      - name: rowCounts
        in: query
        description: Return row counts or not
        required: false
        schema:
          type: boolean
          enum:
          - false
          - true
          default: false
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetStorageTables'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      operationId: getStorageByStorageNameTables
      x-operation-id-source: derived
  /storage/{storageName}/empty-tables:
    post:
      tags:
      - Storage
      summary: Delete all data rows from specified tables in a SQL storage item
      description: ''
      parameters:
      - name: storageName
        in: path
        description: Name of the target storage device
        required: true
        schema:
          type: string
      - name: dryRun
        in: query
        description: When true, do not empty the tables
        required: false
        schema:
          type: boolean
          enum:
          - false
          - true
          default: false
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/EmptyStorageTables'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      requestBody:
        content:
          application/json:
            schema:
              type: object
              properties:
                tables:
                  type: array
                  example:
                  - anura_2_5.customers
                  - anura_2_5.optimizationcustomersummary
                  items:
                    type: string
        description: Array of tables to empty
        required: true
      operationId: postStorageByStorageNameEmptyTables
      x-operation-id-source: derived
  /storage/{storageName}/db-data-export:
    post:
      tags:
      - Storage
      summary: Export all rows from selected tables/views, or the results of a query in a SQL…
      description: ''
      parameters:
      - name: storageName
        in: path
        description: Name of the target storage device
        required: true
        schema:
          type: string
      - name: sourceSchema
        in: query
        description: The schema to export tables/views from. e.g., 'anura_2_6'. Applies to sourceList and sourceGroup, but not sourceQuery.
        required: false
        example: anura_2_5
        schema:
          type: string
      - name: sourceGroup
        in: query
        description: A group of tables/views to export.
        required: false
        schema:
          type: string
          enum:
          - all
          - tables
          - views
          - nonEmptyAll
          - nonEmptyTables
          - nonEmptyViews
      - name: format
        in: query
        description: Output format for the export. Default is 'csv' if not specified.
        required: false
        schema:
          type: string
          enum:
          - csv
          - xls
          - table
          default: csv
      - name: destinationSchema
        in: query
        description: The schema to export query results to when format=table. Default if not specified is 'query_results'.
        required: false
        example: anura_2_8
        schema:
          type: string
      - name: destinationTable
        in: query
        description: The table name to export query results to when format=table. Default if not specified is 'results'.
        required: false
        example: my_new_table
        schema:
          type: string
      responses:
        '202':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DbDataExport'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      requestBody:
        content:
          application/json:
            schema:
              type: object
              properties:
                sourceList:
                  type: array
                  example:
                  - customers
                  - facilities
                  - products
                  items:
                    type: string
                sourceQuery:
                  type: string
                  example: select * from anura_2_6.products where status='Include'
                  items:
                    type: string
        description: An array of tables/views (sourceList) or a SQL query (sourceQuery) to export.
        required: true
      operationId: postStorageByStorageNameDbDataExport
      x-operation-id-source: derived
  /storage/{storageName}/file/move:
    put:
      tags:
      - Storage
      summary: Move a file within a storage device
      description: ''
      parameters:
      - name: storageName
        in: path
        description: Name of the target storage device
        required: true
        schema:
          type: string
      - name: source
        in: query
        description: Target path of the existing file
        required: true
        schema:
          type: string
      - name: dest
        in: query
        description: New path for the targeted file
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/StorageMoveFile'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      operationId: putStorageByStorageNameFileMove
      x-operation-id-source: derived
  /storage/{storageName}/folder/move:
    put:
      tags:
      - Storage
      summary: Move a folder within a storage device
      description: ''
      parameters:
      - name: storageName
        in: path
        description: Name of the target storage device
        required: true
        schema:
          type: string
      - name: source
        in: query
        description: Target directory to move
        required: true
        schema:
          type: string
      - name: dest
        in: query
        description: New location of the targeted directory
        required: true
        schema:
          type: string
      - name: mergeIfTargetExists
        in: query
        description: If true, merge the source directory into the target directory if it exists
        required: false
        schema:
          type: boolean
          default: false
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/StorageMoveDirectory'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      operationId: putStorageByStorageNameFolderMove
      x-operation-id-source: derived
  /storage/{storageName}/folder/copy:
    put:
      tags:
      - Storage
      summary: Copy a folder within a storage device or from one storage device to another
      description: ''
      parameters:
      - name: storageName
        in: path
        description: Name of the target storage device
        required: true
        schema:
          type: string
      - name: source
        in: query
        description: Target directory to copy
        required: true
        schema:
          type: string
      - name: dest
        in: query
        description: Path of the new directory
        required: true
        schema:
          type: string
      - name: destStorageName
        in: query
        description: Name of the target storage device. Defaults to same storage device as storageName if not included
        required: false
        schema:
          type: string
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/StorageCopyDirectory'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '404':
          description: Resource Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
      security:
      - APIKeyHeader: []
      operationId: putStorageByStorageNameFolderCopy
      x-operation-id-source: derived
components:
  schemas:
    StorageSqlConnection:
      type: object
      properties:
        result:
          type: string
          format: string
        raw:
          type: object
          properties:
            host:
              type: string
              format: string
            port:
              type: integer
              format: int64
              example: 6432
            dbname:
              type: string
              format: string
            user:
              type: string
              format: string
            password:
              type: string
              format: string
        connectionStrings:
          type: object
          properties:
            url:
              type: string
              format: string
              example: postgresql://{USER}:{PASSWORD}@{HOST}:{PORT}/{DB_NAME}?sslmode=require
            psql:
              type: string
              format: string
              example: psql "host={HOST} port={PORT} dbname={DB_NAME} user={USER} password={PASSWORD} sslmode=require"
            jdbc:
              type: string
              format: string
              example: jdbc:postgresql://{HOST}:{PORT}/{DB_NAME}?user={USER}&password={PASSWORD}&sslmode=require
            libpq:
              type: string
              format: string
              example: host={HOST} port={PORT} dbname={DB_NAME} user={USER} password={PASSWORD} sslmode=require
            net:
              type: string
              format: string
              example: Server={HOST};Database={DB_NAME};Port={PORT};User Id={USER};Password={PASSWORD};Ssl Mode=Require;
    GetStorageTables:
      type: object
      properties:
        result:
          type: string
          format: string
        schemas:
          type: array
          items:
            properties:
              name:
                description: the name of the schema
                type: string
              tables:
                description: the number of tables in the schema
                type: integer
              is_default_schema:
                description: whether the schema is the default schema
                type: boolean
                default: false
        tables:
          type: array
          items:
            properties:
              name:
                description: the name of the table
                type: string
              schema:
                description: the schema of the table
                type: string
              rows:
                description: number of rows in the table
                type: integer
    Error:
      type: object
      properties:
        result:
          type: string
          format: string
        error:
          type: string
          format: string
        correlationId:
          type: string
          format: uuid
    DbDataExport:
      type: object
      properties:
        result:
          type: string
          format: string
        message:
          type: string
          format: string
        storageId:
          type: string
          format: uuid
        storageName:
          type: string
          format: string
        sourceSchema:
          type: string
          format: string
        sourceGroup:
          type: string
          format: string
        sourceList:
          type: array
          items:
            type: string
            description: tables/views which were specified to export
        sourceQuery:
          type: string
          format: string
        format:
          type: string
          format: string
        jobKey:
          type: string
          format: uuid
    GetDbObjects:
      type: object
      properties:
        result:
          type: string
          format: string
        schemas:
          type: array
          items:
            properties:
              name:
                description: the name of the schema
                type: string
              tableCount:
                type: number
              viewCount:
                type: number
              isDefault:
                type: boolean
              tables:
                type: array
                items:
                  properties:
                    name:
                      description: the name of the table
                      type: string
                    rows:
                      type: number
                    type:
                      type: string
                    category:
                      type: string
                    categoryOrder:
                      type: string
                    technology:
                      type: string
                    isCustom:
                      description: whether the table is custom or not
                      type: boolean
                      default: false
                    abbreviatedName:
                      type: string
              views:
                type: array
                items:
                  properties:
                    name:
                      description: the name of the table
                      type: string
                    rows:
                      type: number
                    type:
                      type: string
                    category:
                      type: string
                    categoryOrder:
                      type: string
                    technology:
                      type: string
                    isCustom:
                      description: whether the table is custom or not
                      type: boolean
                      default: false
    StorageMoveFile:
      type: object
      properties:
        result:
          type: string
          format: string
        message:
          type: string
          format: string
        fileInfo:
          type: object
          properties:
            storageName:
              type: string
              format: string
            directoryPath:
              type: string
              format: string
            filename:
              type: string
              format: string
    StorageCopyDirectory:
      type: object
      properties:
        result:
          type: string
          format: string
        jobKey:
          type: string
          format: uuid
    EmptyStorageTables:
      type: object
      properties:
        result:
          type: string
          format: string
        dryRun:
          type: boolean
        emptied:
          type: array
          items:
            type: string
            description: tables which were emptied
        failed:
          type: array
          items:
            type: string
            description: tables which failed to be emptied
    GetSchema:
      type: object
      properties:
        result:
          type: string
          format: string
        schemas:
          type: array
          items:
            properties:
              name:
                description: the name of the schema
                type: string
              tables:
                type: array
                items:
                  properties:
                    name:
                      description: the name of the table
                      type: string
                    columns:
                      type: array
                      items:
                        properties:
                          name:
                            description: the name of the column
                            type: string
                          dataType:
                            description: the sql data type of the column
                            type: string
                          isCustom:
                            description: whether the column is custom or not
                            type: boolean
                    isCustom:
                      description: whether the table is custom or not
                      type: boolean
                      default: false
              views:
                type: array
                items:
                  properties:
                    name:
                      description: the name of the table
                      type: string
                    columns:
                      type: array
                      items:
                        properties:
                          name:
                            description: the name of the column
                            type: string
                          dataType:
                            description: the sql data type of the column
                            type: string
                          isCustom:
                            description: whether the column is custom or not
                            type: boolean
                    isCustom:
                      description: whether the table is custom or not
                      type: boolean
                      default: false
    StorageMoveDirectory:
      type: object
      properties:
        result:
          type: string
          format: string
        message:
          type: string
          format: string
        storageName:
          type: string
          format: string
        dest:
          type: string
          format: string
    StoragesDBConnectionStrings:
      type: object
      properties:
        result:
          type: string
          format: string
        count:
          type: integer
          example: 1
        storages:
          type: array
          items:
            properties:
              id:
                type: integer
              name:
                type: string
                format: string
              connectionInfo:
                type: object
                properties:
                  raw:
                    type: object
                    properties:
                      host:
                        type: string
                        format: string
                      port:
                        type: integer
                        format: int64
                        example: 6432
                      dbname:
                        type: string
                        format: string
                      user:
                        type: string
                        format: string
                      password:
                        type: string
                        format: string
                      sslmode:
                        type: string
                        format: string
                  connectionStrings:
                    type: object
                    properties:
                      url:
                        type: string
                        format: string
                        example: postgresql://{USER}:{PASSWORD}@{HOST}:{PORT}/{DB_NAME}?sslmode=require
                      psql:
                        type: string
                        format: string
                        example: psql "host={HOST} port={PORT} dbname={DB_NAME} user={USER} password={PASSWORD} sslmode=require"
                      jdbc:
                        type: string
                        format: string
                        example: jdbc:postgresql://{HOST}:{PORT}/{DB_NAME}?user={USER}&password={PASSWORD}&sslmode=require
                      libpq:
                        type: string
                        format: string
                        example: host={HOST} port={PORT} dbname={DB_NAME} user={USER} password={PASSWORD} sslmode=require
                      net:
                        type: string
                        format: string
                        example: Server={HOST};Database={DB_NAME};Port={PORT};User Id={USER};Password={PASSWORD};Ssl Mode=Require;
  securitySchemes:
    APIKeyHeader:
      type: apiKey
      in: header
      name: X-API-KEY
externalDocs:
  description: Find out more about Optilogic
  url: https://optilogic.com