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
- Deployable via binary, Docker, or Helm
Check it out and please share your thoughts!
- Interactive Demo (GitHub needed): https://codespaces.new/centralmind/sample_databases
- GitHub: https://github.com/centralmind/gateway
- Docs: https://docs.centralmind.ai/
- Video: https://youtu.be/5xumga3QjmA
- 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.
Thanks in advance