Skip to content
forked from pixlie/dwata

Manage Databases without knowing SQL. Track User growth, find Sales insights or bottlenecks, share KPIs without engineering.

Notifications You must be signed in to change notification settings

miteshashar/dwata

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Dwata

Understand, monitor or manage Business data without SQL or code. Track User growth, find Sales insights or bottlenecks, share KPIs without engineering.

Home Screen

What is dwata?

  • Complete software for Business insights and operations
  • Query complex data without any SQL or code
  • Share business insights with entire team
  • Onboard team members easily to your Business process
  • Keep track of KPIs from any data source, compare Weekly/Monthly/Quarterly growth
  • Directly integrates with Stripe, Mailchimp, PayPal, Shippo, etc.
  • Build live Reports and Dashboards for customers/suppliers

Automatically infer (reflect) Database structure

Automatically infer Database structure Uses DB Reflection from SQLAlchemy

Modern User Experience

Grid showing columns Show JOINed tables in a nice way

Multi-table merge (1-1, 1-M Relations)

Merge related data There is not SQL to write, everything is visual!

Automatically generates SQL

JOIN, Sub-query, Grouping, Aggregates, etc.

Generates SQL for JOIN or Sub-query

Rich set of UI Elements

Boolean and large text fields

Why would you use dwata?

  • Created with Sales, Marketing, Analyst or any non-Developer in mind
  • No need to invest in Django/Laravel/Rails/Express/... based admin
  • Complete auto-pilot software, does not need Developers' help to operate
  • Enable and encourage everyone to query Business insights and share

Building an admin application is an undifferentiated investment that does not add direct value to your customers.

Some more details on what it does and how it works:

  • dwata scans MySQL/PostgreSQL/SQLite or MongoDB (coming soon)
  • Automatically understands data schema - Tables, Columns, Relations
  • Builds dynamic UI automatically with Grids, Widgets, Column view, etc.
  • Visually allows you to Merge related data, generates SQL for you!
  • Visually apply Aggregates, Averages, Grouping and many other functions (coming soon)
  • Can connect directly with Stripe, PayPal, Mailchimp, etc. (coming soon)
  • Has Widgets for everything from Numbers, Booleans, Large text
  • Dates, Timestamps, Geographic data (with Maps) coming soon
  • Full text search coming soon
  • Internal cache so Queries are not repeated unnecessarily

dwata is in early development stage.

About

Manage Databases without knowing SQL. Track User growth, find Sales insights or bottlenecks, share KPIs without engineering.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 62.4%
  • Python 25.0%
  • CSS 7.5%
  • TypeScript 3.7%
  • HTML 1.3%
  • Shell 0.1%