Step 2 - SQL Query

Execute a SQL query in the Playground

Use the Spice.ai Playground to experiment with SQL queries, APIs, and models directly in app.

It includes:

• A SQL Query Editor for experimentation.

• Interactive API clients and sample code.

SQL Query Editor: querying for UniswapV2 Pool Liquidity Stats

Execute a SQL query using cURL

Once you've set up a Portal account, replace [API-KEY] in the sample below with your API Key from the Spice app.

cURL

curl --request POST \
  --url 'https://data.spiceai.io/v1/sql' \
  --header 'Content-Type: text/plain' \
  --header 'X-API-KEY: [API-KEY]'
  --data 'select * from eth.recent_blocks order by "timestamp" desc'

Visit the FAQ page for more details.

Call the API

To get an API key, set up a Portal account.