Skip to content

Simple, open-source analytics tool for any Postgres database.

License

Notifications You must be signed in to change notification settings

decileapp/decile

Repository files navigation

Decile

We use AI to help you build a data-led organisation.
Early access

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.




This repo contains the open-source code to host your own version of Decile. Join the waitlist for our hosted version.

Contributions welcome!

Have suggestions for what to work on next? We'd love to hear from you. Sign up for early access!


License

We use the GNU GPL V3 license. See LICENSE for more details.


Features

Supported on open source

  • 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 Edior
  • Query without SQL
  • Export to Google Sheets
  • Schedule queries by hour, day, week or month
  • Email notifications
  • Line and bar graphs

Supported on cloud version only

  • Query data using natural language

In-progress

  • Advanced graphs

Backlog

  • Dashboards
  • Database access management

Getting Started

1. Clone this repository

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 + the id for your template
  • Email: Enter an email address you want to invite users from.
  • Google: Google auth + sheets integration
  • Bearer token: token for calling your schedule endpoint

For emailing, please set up an account with Courier and get an API key.

3. Install modules.

Run "npm install" in your terminal to install all your modules.

4. Run it locally

Run "npm run" to start your local version at http://localhost:3000

5. Deploy to your favorite server!

Important! Remember to add your dashboard URL to your list of your sign-up redirect URLs in Supabase. You can find it at https://app.supabase.io/project/YOUR_PROJECT_ID/auth/settings.