Get the data you need by just asking, learn SQL in the process.
Connect any Postgres database. Save and share queries with your team. Export to Google Sheets. Schedule queries and automatically update your Google Sheet.
Key Features of Decile
- Authentication UIs including sign in and sign up
- Google sign in
- Invite your team to share queries
- Admin and user roles
- Add any Postgres database
- Online SQL Editor
- Query without SQL
- Export to Google Sheets
- Schedule queries by hour, day, week, or month
- Email notifications
- Line and bar graphs
Getting Started with Decile
Follow these steps to set up your own version of Decile:
1. Clone the Repository
Start by cloning the Decile repository using the following command:
bash
git clone https://github.com/decileapp/decile
cd decile
2. Configure Your Environment Variables
Change env.example
to env.local
. Get your API keys for each service and complete the file:
- Supabase: database
- Mixpanel: analytics
- Courier: emails + template ID
- Email: Enter an email address to invite users from
- Google: Google auth + sheets integration
- Bearer token: token for calling your schedule endpoint
For email functionality, set up an account with Courier to obtain an API key.
3. Install Modules
Run the following command to install all necessary modules:
npm install
4. Run it Locally
To start your local version, run:
npm run
Your local setup will be accessible at http://localhost:3000.
5. Deploy to Your Favorite Server
Deploy your application to the server of your choice. Don’t forget to add your dashboard URL to the sign-up redirect URLs in Supabase. You can find the settings at Supabase Auth Settings.
An Analogous Insight
Think of setting up Decile like preparing a gourmet meal:
- Cloning the repository is like gathering your ingredients – you need everything in one place before you start cooking.
- Configuring your environment variables parallels measuring out your spices and seasonings – each detail is crucial to achieving the perfect flavor.
- Installing modules acts like preheating your oven – it’s an essential step to ensure everything runs smoothly while cooking.
- Running it locally is akin to tasting your dish before serving; you want to ensure everything is just right.
- Deploying to your chosen server is like plating your dish for guests – it’s time to present your beautifully crafted meal to the world!
Troubleshooting
If you encounter issues as you set up your instance of Decile, consider the following ideas:
- Check your API keys – if an external service isn’t connecting, there may be an issue with your keys.
- Review your environment variable settings; even small typos can cause significant problems.
- Ensure that your local server is running correctly – a quick restart can often resolve many issues.
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.