Skip to main content

Data API

Transform Your Data into Accessible APIs​

After mirroring your data to ClickHouse, ClickPipes allows you to expose this data as HTTP APIs without writing any code. This powerful feature enables you to:

  • Make your data accessible to applications and services
  • Create secure endpoints with fine-grained access control
  • Transform complex SQL queries into simple API calls
  • Enable non-technical users to access data insights

How It Works​

  1. Write SQL: Create a SQL query in ClickHouse that retrieves the exact data you need
  2. Configure API: Set up parameters, authentication, and access controls
  3. Publish: Make your API available with a single click
  4. Consume: Access your data via HTTP requests from any application

Key Features​

SQL-to-API Conversion​

Transform any SQL query into a RESTful API endpoint with just a few clicks. Your complex data models become instantly accessible through standard HTTP requests.

Parameterized Queries​

Create flexible APIs by adding parameters to your SQL queries. This allows consumers to filter, sort, and customize the data they receive.

AI-Powered Query Generation​

Don't know SQL? No problem! Our AI assistant can generate SQL queries from natural language descriptions. Simply describe what data you need, and the AI will create the appropriate SQL.

Pricing and Usage​

ClickPipes Data API is billed based on:

  • Data transfer volume
  • AI token usage (for AI-generated queries)

Free Monthly Allowance:

  • 100,000 AI tokens per month at no charge
  • Basic API calls included in your subscription

For detailed information, see: