Hey I'm Victor!
My team and I built CentralMind Getaway just recently, an open-source tool that auto-generates secure and AI-optimized APIs from structured data. It's for those who don't want to expose direct SQL access to their databases to AI-Agents and spend time building these APIs manually.
What it does:
- Auto-generates APIs from your database schema & sample data using AI
- Filters out PII and sensitive data for compliance (GDPR, SOC 2, etc.)
- Optimized for AI with extra meta information for REST and MCP support
- Works with PostgreSQL, MySQL, ClickHouse, Snowflake, BiqQuery
- Bunch of plugins: Telemetry, Auth, Caching, RLS and others
Using ChatGPT and AI assistants over the past year, here are my best use cases:
- Generating wrappers and simple CRUD APIs on top of database tables, provided only with a DDL of the tables.
- Optimizing SQL queries and schemas, especially for less familiar SQL dialects—extremely effective.
- Generating Swagger comments for API methods. Joyness
- Re-creating classes or components based on similar classes, especially with Next.js, where the component mechanics often make this necessary.
- Creating utility methods for data conversion or mapping between different formats or structures.
- Assisting with CSS and the intricacies of HTML for styling.
- GPT4 o1 is significantly better at handling more complex scenarios in creation and refactoring.
Current challenges based on my experience:
- LLM lacks critical thinking; they tend to accommodate the user’s input even if the question is flawed or lacks a valid answer.
- There’s a substantial lack of context in most cases. LLMs should integrate deeper with data sampling capabilities or, ideally, support real-time debugging context.
- Challenging to use in large projects due to limited awareness of project structure and dependencies.
We're curious about your thoughts on Snowflake and the idea of an open-source alternative. Developing such a solution would require significant resources, but there might be an existing in-house project somewhere that could be open-sourced, who knows.
Could you spare a few minutes to fill out a short 10-question survey and share your experiences and insights about Snowflake? As a thank you, we have a few $50 Amazon gift cards that we will randomly share with those who complete the survey.