Welcome to your guide on using the innovative app designed to harness the power of Large Language Models (LLMs) to query SQL databases effortlessly using natural language. With this tool, you can interact with your database just as you would in a conversation.
Getting Started
Follow these steps to set up and run the application on your local machine:
1. Installation
To install the app, you will need to execute a couple of commands in your terminal. Make sure you have Node.js installed on your machine.
bash
npm install
2. Configuration
Before running the app, you need to configure your OpenAI API key. This key allows the app to communicate with OpenAI’s models.
- Open the
.env.localfile located in your project directory. - Add your OpenAI API key in the format:
OPENAI_API_KEY=your_api_key_here
3. Running the App
Now, let’s start the application! You can run the following command:
bash
npm run dev
This command launches the app, allowing you to start querying your SQL database with natural language!
Visualizing the Database
Here’s a sample of the Northwind database you’ll be able to interact with:
See It in Action
Curious about how it works? Here are some video demonstrations:
Troubleshooting
If you encounter issues during installation or while running the app, consider the following troubleshooting tips:
- Ensure Node.js is installed correctly and is the latest version.
- Double-check your OpenAI API key, making sure it is valid and correctly entered in the
.env.localfile. - If you run into problems after installation, try removing the
node_modulesfolder and runningnpm installagain.
For more insights, updates, or to collaborate on AI development projects, stay connected with fxis.ai.
Conclusion
At fxis.ai, we believe that such advancements are crucial for the future of AI, as they enable more comprehensive and effective solutions. Our team is continually exploring new methodologies to push the envelope in artificial intelligence, ensuring that our clients benefit from the latest technological innovations.