Build Analytics APIs from parameterized SQL
Get started now
Build APIs from SQL
Use only SQL to build your scalable and flexible APIs.
Dynamic SQL generation
Generate corresponding SQL based on personas and context on the fly.
Scalable and Extendable
Modular and extendable with your custom business logic at scale.
What is VulcanSQL?
VulcanSQL is an Analytics API generator that helps data engineers to build scalable analytics APIs using only SQL without writing any backend code.
Parameterized your SQL
Build APIs with just parameterized your SQL and with extendability. Learn about building API.
Comprehensive API methods
Included dynamic parameters, validation, error response, response format, etc.- Dynamic parameters
- Validation
- Error response
- Response format
SELECT * FROM public.users
WHERE age >= {{ context.params.age }} AND {{ context.params.age }} <= 19;
urlPath: /orders/order_id
request:
- fieldName: orders_id
fieldIn: path
validators:
- required
- uuid
{% req user %}
SELECT COUNT(*) AS count FROM customers WHERE name = {{ context.params.name }}
{% endreq %}
{% if user.value()[0].count == 0 %}
{% error "CUSTOMER_NOT_FOUND" %}
{% endif %}
SELECT * FROM customers
WHERE name = {{ context.params.name }}
LIMIT 1
response-format:
enabled: true
options:
default: json
formats:
- json
- csv
Access control in SQL
SQL knows who you are and what you can retrieve. Learn about access control.SELECT
--- masking address if query user is not admin
{% if context.user.attr.role == 'ADMIN' %}
address
{% elif %}
{{ masking('address') }}
{% endif %},
orderId,
amount
FROM orders
--- limit the data to the store user belongs to.
WHERE store = {{ context.user.attr.store }}
API docs & catalog
Automatically build complete API documentation(OpenAPI) and catalog for data consumers and web engineer. Learn about API documentation.
Connect from business applications
Preview data and self-serve interface to read from your own business applications or export into files.
Ready to dive in?
Join our developer community
Join the discord group to chat with the developers and directly connect with the VulcanSQL team.