Decile: Build a Data-Led Organisation with AI

Mar 14, 2024 | Programming

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.

Stay Informed with the Newest F(x) Insights and Blogs

Tech News and Blog Highlights, Straight to Your Inbox