Skip to content

Canner/vulcan-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

What is VulcanSQL?

VulcanSQL is an Analytical Data API Framework for AI agents and data apps. It aims to help data professionals deliver RESTful APIs from databases, data warehouses or data lakes much easier and secure. It turns your SQL into APIs in no time!

overview of VulcanSQL

Why VulcanSQL?

Given the vast amount of analytical data in databases, data warehouses, and data lakes, there is currently no easy method for data professionals to share data with relevant stakeholders for operational business use cases.

Without a specialized framework to streamline the creation of APIs for AI agents and apps to interact with databases and data warehouses, developers today must undertake a more manual and complex process. This approach comes with several pain points and challenges:

Traditional Approach and Pain Points

1. Custom API Development:

  • Time-Consuming: Developers need to manually code the APIs, which can be time-consuming, especially for complex applications or when dealing with multiple data sources.
  • Error-Prone: Manual coding increases the risk of bugs and errors, which can affect the reliability and performance of the APIs.

2. Integration Complexity:

  • Diverse Data Sources: Integrating multiple data sources with different formats and protocols requires significant effort and expertise.
  • Lack of Standardization: Without a standardized approach, each API might follow different conventions, making it harder for AI agents to interact with them consistently.

3. Security and Compliance:

  • Security Risks: Ensuring that APIs are secure and that data access complies with regulations (e.g., GDPR, HIPAA) requires additional layers of work, including authentication, authorization, and data encryption.
  • Maintenance Overhead: Security and compliance requirements can evolve, necessitating ongoing maintenance and updates to the APIs.

4. Scalability and Performance:

  • Scalability Concerns: Custom-built APIs may not be optimized for scalability, leading to performance issues as the number of requests or the volume of data grows.
  • Resource Intensive: Optimizing for performance and scalability can require significant resources, both in terms of development time and infrastructure.

5. Documentation and Usability:

  • Lack of Documentation: Properly documenting APIs for easy understanding and use by other developers or AI agents can be overlooked or undervalued.
  • Usability Issues: Without clear and comprehensive documentation, it becomes challenging for others to integrate with and effectively use the APIs.

With VulcanSQL you can

  • Rapid Development and Integration: By abstracting the complexities of directly interacting with databases and data warehouses, developers can focus on the higher-level logic of their applications. This reduces the development time and simplifies the process of integrating AI capabilities into applications.

  • Standardization: Utilizing OpenAPI documents for interaction provides a standardized way for AI agents to understand and interact with different APIs. This promotes interoperability among various systems and tools, making it easier to integrate with a wide array of services and data sources.

  • Scalability and Maintenance: A template-driven approach to API creation can make it easier to scale and maintain APIs over time. Changes in the underlying data schema or business logic can be propagated to the APIs more efficiently, without the need for extensive manual adjustments.

  • Accessibility: Making data more accessible to AI agents through well-defined APIs can unlock new insights and capabilities by leveraging machine learning and analytics. This can enhance decision-making processes and automate routine tasks, among other benefits.

Online Playground

Use Online Playground to get a taste of VulcanSQL!

Installation

Please visit the installation guide.

Examples

Need inspiration? Here are a selected compilation of examples showcasing how you can use VulcanSQL!

How VulcanSQL works?

πŸ’» Build

VulcanSQL offers a development experience similar to dbt. Just insert variables into your templated SQL. VulcanSQL accepts input from your API and generates SQL statements on the fly.

πŸš€ Accelerate

VulcanSQL uses DuckDB as a caching layer, boosting your query speed and reducing API response time. This means faster, smoother data APIs for you and less strain on your data sources.

πŸ”₯ Deploy

VulcanSQL offers flexible deployment options - whether you prefer Docker or command-based setups. Our package command assists in bundling your assets, ensuring a smooth transition from development to deployment of your data APIs.

❀️ Share

VulcanSQL offers many data sharing options, seamlessly integrating your data into familiar applications within your workflow and build AI agents.

Documentation

Below are some common scenarios that you may be interested:

Use Cases

πŸ€– AI agents: Streamline the creation of APIs for AI agents to interact with databases and data warehouses.

πŸ“ˆ Customer-facing analytics: Expose analytics in your SaaS product for customers to understand how the product is performing for them via customer dashboards, insights, and reports.

πŸ‘ Data sharing: Sharing data with partners, vendors, or customers, which requires a secure and scalable way to expose data.

βš™οΈ Internal tools: Integration with internal tools like Zapier, AppSmith and Retools, etc.

Community