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 decile2. 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.