Evidence USQL / Query Layer

Universal SQL, the query engine built into Evidence core and powered by DuckDB's WebAssembly distribution. It extracts data sources to Parquet and lets you query across multiple sources with a single SQL dialect via an open data-source-adapter standard. Consumed in-process through SQL, not via a network REST endpoint.

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/usql-query-layer"
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 email required.

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

OpenAPI Specification

evidence-dev-openapi.yml Raw ↑
openapi: 3.0.1
info:
  title: Evidence (Framework - not a REST API)
  description: >-
    Evidence is an open-source (MIT) business-intelligence-as-code framework, not a
    hosted REST API. It compiles SQL queries embedded in Markdown files into a static
    data app / BI website using Svelte and Vite, and executes those queries through a
    DuckDB-WebAssembly "Universal SQL" engine that extracts data sources to Parquet.
    The product is consumed as a Node CLI (for example: `npm run sources`, `npm run
    dev`, `npm run build`, `npm run preview`) plus authored Markdown and SQL - there
    is no documented public HTTP/REST request-response API surface to model. Evidence
    Cloud provides managed hosting, a managed query engine, scheduled syncs, and AI
    authoring assistance, but does not expose a documented public REST API for end
    users. This document therefore declares an empty `paths` object rather than
    fabricating REST endpoints. See https://docs.evidence.dev/ and
    https://docs.evidence.dev/reference/cli for the actual framework/CLI interface.
  termsOfService: https://evidence.dev/
  contact:
    name: Evidence Support
    url: https://evidence.dev/
  license:
    name: MIT
    url: https://github.com/evidence-dev/evidence/blob/main/LICENSE
  version: '1.0'
servers:
  - url: https://evidence.dev
    description: >-
      Marketing and documentation site only. Evidence has no public REST API base
      URL; this entry exists because OpenAPI requires a server and must not be read
      as an API endpoint.
paths: {}
components: {}