> For the complete documentation index, see [llms.txt](https://docs.koinju.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.koinju.io/sql-api-specifics.md).

# SQL API Specifics

For SQL query limits and quotas per tier, see [Pricing](/pricing.md).

## Tables and schema discovery

While this documentation provides the tables' description it can always be generated by querying the table.

### List all available tables

```sql
SHOW tables from api
```

*Example Output:*

```
┌─name──────────────────────┐
│ market_future             │
│ market_option             │
│ market_spot               │
│ ohlcv                     │
│ trade                     │
└───────────────────────────┘

```

### Describe a table

```sql
DESCRIBE api.market_future
```

*Example Output:*

```
+------------------------+-----------------------+
|name                    |type                   |
+------------------------+-----------------------+
|exchange                |LowCardinality(String) |
|market_symbol           |Nullable(String)       |
|underlying_asset        |String                 |
|quote_asset             |String                 |
|settling_asset          |String                 |
|denomination_asset      |String                 |
|expiration              |Nullable(DateTime64(9))|
|contract_size           |Decimal(38, 18)        |
|contract_type           |String                 |
|future_type             |String                 |
|exchange_specific_symbol|String                 |
+------------------------+-----------------------+

```