Coder Social home page Coder Social logo

decileapp / decile Goto Github PK

View Code? Open in Web Editor NEW
134.0 2.0 8.0 1.34 MB

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

Home Page: https://decile.app

License: GNU General Public License v3.0

TypeScript 99.81% JavaScript 0.18% CSS 0.01%
analytics postgres sql automation business dashboard data intelligence reporting sql-editor

decile's Introduction

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.

decile's People

Contributors

ntkris avatar saminnet avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

decile's Issues

email templateId

Hard coded as

templateId: "Z6V0E3HEAHM63SKRA3B05RKVR9AE",

should be refactored as an env variable?

Is it Courrier template or mailjet, same example of the content can help for self-install

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.