Optimizely

Optimizely Database Scripts API

The Database Scripts API from Optimizely — 5 operation(s) for database scripts.

GitHub OpenAPI

Operations 9

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

GET /api/v1/admin/DatabaseScripts List applied database scripts · Returns the EntitySet DatabaseScripts #
Ask an LLM
“Which database upgrade scripts have been applied to my commerce instance?”
“Can I sort database scripts by when they were applied?”
Tell an agent
List all database scripts.
List database scripts matching {filter}, ordered by {orderby}.
POST /api/v1/admin/DatabaseScripts Record a database script · Post a new entity to EntitySet DatabaseScripts #
Ask an LLM
“How do I record that a database script was applied?”
“Can I log a script's run time when registering it?”
Tell an agent
Record database script {scriptName}.
Record script {scriptName} applied on {appliedOn} with run time {runTime}.
GET /api/v1/admin/DatabaseScripts({id}) Get a database script record · Returns the entity with the key from DatabaseScripts #
Ask an LLM
“How do I check when one database script was applied?”
“How long did a specific database script take to run?”
Tell an agent
Get database script {id}.
Show when database script {id} was applied.
PUT /api/v1/admin/DatabaseScripts({id}) Replace a database script record · Replace entity in EntitySet DatabaseScripts #
Ask an LLM
“How do I overwrite a database script record in full?”
“Does replacing a script record need the script name again?”
Tell an agent
Replace database script {id} with name {scriptName}.
Fully overwrite script record {id} with applied date {appliedOn}.
DELETE /api/v1/admin/DatabaseScripts({id}) Delete a database script record · Delete entity in EntitySet DatabaseScripts #
Ask an LLM
“How do I remove a database script record?”
“Can I delete a script record only if its ETag still matches?”
Tell an agent destructive · confirm first
Delete database script {id}.
Delete database script record {id} if its ETag is {etag}.
PATCH /api/v1/admin/DatabaseScripts({id}) Update a database script record · Update entity in EntitySet DatabaseScripts #
Ask an LLM
“How do I correct the run time logged for a database script?”
“Can I change just the applied date on a script record?”
Tell an agent
Set run time of database script {id} to {runTime}.
Change applied date of script record {id} to {appliedOn}.
GET /api/v1/admin/DatabaseScripts/Default.Default() Get the default database script template · Call operation Default #
Ask an LLM
“What default values does a new database script record start with?”
“Where can I get a blank database script record?”
Tell an agent
Get the default database script template.
Show default values for a new database script record.
DELETE /api/v1/admin/databasescripts/delete Bulk delete database script records · Database scripts delete route #
Ask an LLM
“How do I delete several database script records at once?”
“Can I bulk remove script records by id?”
Tell an agent destructive · confirm first
Delete database scripts {ids}.
Bulk remove database script records {ids}.
GET /api/v1/admin/databasescripts({key})/customproperties({custompropertyKey}) Get a database script custom property · Database scripts get custom property by key and custompropertykey #
Ask an LLM
“How do I read a custom property on a database script record?”
“Where is one custom property value for a database script?”
Tell an agent
Get custom property {custompropertyKey} of database script {key}.
Show database script {key}'s custom property {custompropertyKey}.

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/optimizely/refs/heads/main/openapi/optimizely-database-scripts-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/optimizely:optimizely-database-scripts-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

optimizely-database-scripts-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  version: admin-v1
  title: Admin API V1 Database Scripts API
servers:
- url: https://dogfood.commerce.insitesandbox.com
security: []
tags:
- name: Database Scripts
paths:
  /api/v1/admin/DatabaseScripts:
    get:
      tags:
      - Database Scripts
      summary: Returns the EntitySet DatabaseScripts
      operationId: DatabaseScripts_Get
      parameters:
      - name: $expand
        in: query
        description: Expands related entities inline.
        required: false
        schema:
          type: string
      - name: $filter
        in: query
        description: Filters the results, based on a Boolean condition.
        required: false
        schema:
          type: string
      - name: $select
        in: query
        description: Selects which properties to include in the response.
        required: false
        schema:
          type: string
      - name: $apply
        in: query
        description: Aggregates the results according to one or more transformations.
        required: false
        schema:
          type: string
      - name: $orderby
        in: query
        description: Sorts the results.
        required: false
        schema:
          type: string
      - name: $top
        in: query
        description: Returns only the first n results.
        required: false
        schema:
          type: integer
          format: int32
      - name: $skip
        in: query
        description: Skips the first n results.
        required: false
        schema:
          type: integer
          format: int32
      - name: $count
        in: query
        description: Includes a count of the matching results in the response.
        required: false
        schema:
          type: boolean
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: object
      deprecated: false
      security:
      - access_token: []
    post:
      tags:
      - Database Scripts
      summary: Post a new entity to EntitySet DatabaseScripts
      operationId: DatabaseScripts_Post
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/Insite.Data.Entities.DatabaseScript'
        description: The entity to post
        required: true
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: object
      deprecated: false
      security:
      - access_token: []
  /api/v1/admin/DatabaseScripts({id}):
    get:
      tags:
      - Database Scripts
      summary: Returns the entity with the key from DatabaseScripts
      operationId: DatabaseScripts_GetById
      parameters:
      - name: id
        in: path
        description: 'key: id'
        required: true
        schema:
          type: string
          format: uuid
      - name: $expand
        in: query
        description: Expands related entities inline.
        required: false
        schema:
          type: string
      - name: $select
        in: query
        description: Selects which properties to include in the response.
        required: false
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: object
      deprecated: false
      security:
      - access_token: []
    put:
      tags:
      - Database Scripts
      summary: Replace entity in EntitySet DatabaseScripts
      operationId: DatabaseScripts_PutById
      parameters:
      - name: id
        in: path
        description: 'key: id'
        required: true
        schema:
          type: string
          format: uuid
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/Insite.Data.Entities.DatabaseScript'
        description: The entity to put
        required: true
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: object
      deprecated: false
      security:
      - access_token: []
    delete:
      tags:
      - Database Scripts
      summary: Delete entity in EntitySet DatabaseScripts
      operationId: DatabaseScripts_DeleteById
      parameters:
      - name: id
        in: path
        description: 'key: id'
        required: true
        schema:
          type: string
          format: uuid
      - name: If-Match
        in: header
        description: If-Match header
        required: false
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: object
      deprecated: false
      security:
      - access_token: []
    patch:
      tags:
      - Database Scripts
      summary: Update entity in EntitySet DatabaseScripts
      operationId: DatabaseScripts_PatchById
      parameters:
      - name: id
        in: path
        description: 'key: id'
        required: true
        schema:
          type: string
          format: uuid
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/Insite.Data.Entities.DatabaseScript'
        description: The entity to patch
        required: true
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: object
      deprecated: false
      security:
      - access_token: []
  /api/v1/admin/DatabaseScripts/Default.Default():
    get:
      tags:
      - Database Scripts
      summary: Call operation Default
      operationId: DatabaseScripts_Default
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: object
      deprecated: false
      security:
      - access_token: []
  /api/v1/admin/databasescripts/delete:
    delete:
      tags:
      - Database Scripts
      operationId: DatabaseScripts_DeleteRoute
      parameters:
      - name: ids
        in: query
        required: true
        explode: true
        schema:
          type: array
          items:
            type: string
            format: uuid
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: object
      deprecated: false
      security:
      - access_token: []
      summary: Database scripts delete route
      x-summary-source: derived
  /api/v1/admin/databasescripts({key})/customproperties({custompropertyKey}):
    get:
      tags:
      - Database Scripts
      operationId: DatabaseScripts_GetCustomPropertyByKeyAndCustompropertykey
      parameters:
      - name: key
        in: path
        required: true
        schema:
          type: string
          format: uuid
      - name: custompropertyKey
        in: path
        required: true
        schema:
          type: string
          format: uuid
      - name: $expand
        in: query
        description: Expands related entities inline.
        required: false
        schema:
          type: string
      - name: $select
        in: query
        description: Selects which properties to include in the response.
        required: false
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            '*/*':
              schema:
                type: object
      deprecated: false
      security:
      - access_token: []
      summary: Database scripts get custom property by key and custompropertykey
      x-summary-source: derived
components:
  schemas:
    Insite.Data.Entities.DatabaseScript:
      required:
      - scriptName
      type: object
      properties:
        id:
          format: uuid
          type: string
          example: 00000000-0000-0000-0000-000000000000
        scriptName:
          maxLength: 255
          minLength: 0
          type: string
        appliedOn:
          format: date-time
          type: string
        runTime:
          format: float
          type: number
        createdOn:
          format: date-time
          type: string
        createdBy:
          type: string
        modifiedOn:
          format: date-time
          type: string
        modifiedBy:
          type: string
  securitySchemes:
    access_token:
      type: apiKey
      description: Token used to access storefront API.
      name: access_token
      in: query