Check out REX - AI Decision Intelligenceย
My open-source platform with a ton of micro-apps and tooling's for AI driven analytics and data science
ย
As shown in my earlier posts and videos (https://lnkd.in/gd5_Pr5V), REX-2 makes connecting to your MySQL or PostgreSQL databases pretty easy. It enables you to chat, query, transform, and analyze data using natural language or voice inputs (NL-Voice-to-SQL). You can also perform basic statistical analysis and generate Python-based charts with ease
ย
Now, in this post and video, I show how to connect REX-2โs FastAPI backend to a custom GPT in minutes, letting you chat and analyze any database through the familiar ChatGPT interface.ย
ย
For decision-makers: Now you have two flexible options: the REX UI or the ChatGPT UI.
ย ย
For hands-on implementers: enjoy rapid deployment, and the ability to customize both UIs and backends to fit many different use cases.
ย
โธHereโs how you can set it up in minutes
Source Code on GitHub: https://lnkd.in/guHqCHVPย ย
Video Guide: https://lnkd.in/gfAm7CSnย demo + 7.5-minute walkthrough).ย
ย
Quick Steps: Click 'Create a GPT', add ready to use instructions and JSON schema. With this the Custom GPT is live within a minute, and can connect to any database. You can use it for testing. Then, deploy FastAPI code on Render to setup your own endpoint. All it takes is a few clicks.
ย
Thatโs it!
ย
ย
โธAdditional ย ย
1. Want to try out the published Custom GPT?
REX-2 | Connect to any database: https://lnkd.in/gi-bw5C6ย ย
Note: Setting up a custom GPT requires a GPT Plus subscription, but free users can still access existing GPTs with some limitations.ย ย
ย
2. Want to Create a New Database Instantly?
Platforms like Neon, Aiven, and Supabase make it easy to create a database in minutes, with user-friendly interfaces and free tiers for smaller use cases.ย ย
If speed is key, REX-2 can spin up a temporary database on Neonโjust hit โCreate DB.โ For a detailed walkthrough, my main video includes a 10-minute section with timestamps for easy navigation.ย
ย
3. Want to upload files to your database?
See my original video or this shorter one:ย ย
Your AI Analyst on Call - REX-2: https://lnkd.in/ggCe5V38ย
ย
4. Want a deeper dive into the architecture and technical flow?
Check out this guide on Medium (Free link)
- FastAPI SQL connector and deployment on Render.ย ย
- How to create Custom JSON action schemas for OpenAI.ย ย
- Resources for exploring FastAPI and integration best practices.ย ย
It was originally written for a slightly different endpoint, but it provides a comprehensive guide to setting up Custom GPTs and connecting them to external resources.