Dosea

A dosea (daw-see-ey) for your datasets

Take a gander at the demo.

Features

• Supports Sqlite, Postgres, CSV, Prometheus
• Readonly DB connections
• Detailed query results
• Detailed Table Schema
• Sqlite Sqlean extensions for math and stats aggregation
• Charts powered by Echarts
• Fully responsive UI for mobile, tablet, and desktop
• Supports Light, Dark, and System UI themes

Run it at home

Copy the .env file and add your information to it.

cp .env.example .env

Install dependencies

npm install

Start dev server:

npm run dev

Run it in Production

npm run start

Roadmap

• User Authentication
• Support for mysql
• Support for influx
• Support for JSON, XML, YAML
• Support for Google Sheets, Excel
• Dashboards
• Themes
• Rich SQL editor with code completion & time range & delta utilities
• Rich chart editor
• Stock chart templates for common use-cases
• Embeddable charts via web components
• Scheduled PDF and email reports
• Explore AI integrations to generate queries and charts based on user prompts

License

Dosea is open-source under the GNU Affero General Public License Version 3 (AGPLv3) or any later version. You can find it here.