Build Analytics APIs From Parameterized SQL
Get started now
Create Robust APIs with SQL
Harness the simplicity of SQL to develop scalable and flexible APIs, tailor-made for your needs.
Dynamic SQL Generation
Generate context-specific SQL tailored to various personas in real time.
Extendable and Scalable
Modular and extendable with your custom business logic at scale.
What is VulcanSQL?
VulcanSQL is an Analytics API framework that helps data analysts to build scalable analytics APIs using only SQL without writing any backend experience.
Parameterized Your SQL
Build APIs with parameterized SQL for seamless extendability. Discover more about API creation.
Comprehensive API Methods
Our built-in methods include Dynamic Parameters, API Validation, Error Handling, Various Response Formats, 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 Data Privacy.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 }}
Automated API Docs & Catalog
Generate complete API documentation (OpenAPI) and catalogs automatically, providing a valuable resource for data consumers and web engineers alike. Learn about API documentation.
Connect from Business Applications
Preview data through our user-friendly interface, which allows you to easily read from your own business applications or export data 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.