Screenpipe Database API

Direct database access

Operations 2

POST /raw_sql Execute raw SQL #
POST /add Add content to database #

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/screenpipe-database-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

screenpipe-database-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: Screenpipe Activity Database API
  version: 1.0.0
  description: 'Screenpipe captures everything you see, say, and hear on your computer. Use this API to search through captured content, manage recordings, and build AI-powered automations on top of your screen data.


    The server runs locally at `http://localhost:3030` by default.'
servers:
- url: http://localhost:3030
  description: Base URL declared by the provider in apis.yml (roadmap#122).
tags:
- name: Database
  description: Direct database access
paths:
  /raw_sql:
    post:
      operationId: routes_content_execute_raw_sql
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/RawSqlQuery'
        required: true
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                type: object
      tags:
      - Database
      summary: Execute raw SQL
      description: Execute a raw SQL query against the screenpipe database. Use with caution.
  /add:
    post:
      operationId: routes_content_add_to_database
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/AddContentRequest'
        required: true
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AddContentResponse'
      tags:
      - Database
      summary: Add content to database
      description: Manually insert screen or audio content into the database.
components:
  schemas:
    RawSqlQuery:
      type: object
      properties:
        query:
          type: string
      required:
      - query
    ContentData:
      oneOf:
      - type: array
        items:
          type: object
          properties:
            file_path:
              type: string
            timestamp:
              type:
              - string
              - 'null'
              format: date-time
            app_name:
              type:
              - string
              - 'null'
            window_name:
              type:
              - string
              - 'null'
            ocr_results:
              type:
              - array
              - 'null'
              items:
                $ref: '#/components/schemas/OCRResult'
            tags:
              type:
              - array
              - 'null'
              items:
                type: string
          required:
          - file_path
          - timestamp
          - app_name
          - window_name
          - ocr_results
          - tags
      - type: object
        properties:
          transcription:
            type: string
          transcription_engine:
            type: string
        required:
        - transcription
        - transcription_engine
    AddContentData:
      type: object
      properties:
        content_type:
          type: string
        data:
          $ref: '#/components/schemas/ContentData'
      required:
      - content_type
      - data
    OCRResult:
      type: object
      properties:
        text:
          type: string
        text_json:
          type:
          - string
          - 'null'
        ocr_engine:
          type:
          - string
          - 'null'
        focused:
          type:
          - boolean
          - 'null'
      required:
      - text
      - text_json
      - ocr_engine
      - focused
    AddContentRequest:
      type: object
      properties:
        device_name:
          type: string
        content:
          $ref: '#/components/schemas/AddContentData'
      required:
      - device_name
      - content
    AddContentResponse:
      type: object
      properties:
        success:
          type: boolean
        message:
          type:
          - string
          - 'null'
      required:
      - success
      - message