dvliman / dwata

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

Dwata

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

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

Uses DB Reflection from SQLAlchemy

Modern User Experience

Show JOINed tables in a nice way

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

There is not SQL to write, everything is visual!

Automatically generates SQL

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

Rich set of UI Elements

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.