
DrawSQL
DBDiagram.io
Azimutt
MySQL Workbench
DbSchema
PopSQL
ChartDB
LucidChart
Grapple
Looker
Tableau
Microsoft Power BI
DataPalo
Datakit.page
Google Data Studio
Coefficient.io
DrawSQL is a simple, beautiful database diagram editor for developers to ๐ง create, ๐ฌ collaborate and ๐ visualize their entity relationship diagrams.
DrawSQL
GrappleGrapple's answer:
Grapple is built for small to medium-sized companies who haven't successfully implemented traditional BI software like Looker, Power BI, Tableau, or other solutions like DataRails and Domo. Traditional BI software requires a lot of technical knowledge to setup, maintain, and they often make it really difficult for less technical users to customize. This means your dashboards either 1) don't work, or 2) aren't flexible and easy to use enough to let operators adjust them as they need during the course of businesses.
Grapple is designed from the beginning for non-technical operators across marketing, sales, and finance.
Grapple's answer:
Grapple is great for data savvy operators who love working with data. We're particularly helpful for companies with 25 to 500 employees who serve other businesses (B2B) and are focused on improving their CRM analytics and SaaS metrics. If you're using apps like Salesforce, Hubspot, Zendesk, Stripe, or Asana, Grapple is for you!
If you want to write data notebooks in python or SQL and want under-the-hood control of your data stack, Grapple is not for you. We recommend you try Omni or Hex.
Grapple's answer:
Jack, co-founder/CEO, had the idea for Grapple a couple years ago after spending almost a decade building in Tableau, Looker, Google Data Studio, Trevor.io, and the list goes on! Jack spent a lot of time collaborating with non-technical users in sales, marketing, bizops, finance on dashboards and after one particularly simple report that was still difficult to generate, he thought there must be a better way! Turns out, most data platforms require a ton of other tools and a ton of other people all of which are slow and expensiveโdelaying your time-to-insight. Jack had the idea to compress the data stack into a single tool, that maybe couldn't do everything, but would be the fastest, easiest way to pull the types of reports he pulled all the time over the last 10 years. Fast-forward to today, Andrew joined as co-founder/CTO and Grapple is now generally available and includes a suite of AI features to take Grapple's speed and ease of use even further. Let us know what you think!
Grapple's answer:
Grapple is a fully vertically integrated data platform and does not require any additional tooling. Unlike competitors Looker and PowerBI, Grapple includes everything you need to get started. Frustrated by your slow data team? Get started with Grapple right away.
In nerd speak, Grapple seamlessly bundles the following tools, you won't even need to manage them: - An ETL and data warehouse for centralizing your data - Automatic data modeling so your data is queryable right away - Visualization and analytics UI
And on top of all that, Grapple provides modern functionality too: - Unlimited Viewers: share your dashboards with as many users as you want, just like a Google Docs - AI/Natural Language: customize your dashboard with natural language instead of SQL or spreadsheet formulas - Straightforward pricing: pay as you go with monthly per user pricing
Grapple's answer:
Grapple's application layer is written in React + Laravel and under the hood uses a mixture of PostgreSQL and No-SQL to deliver data warehousing and analytics capabilities.
Based on our record, DrawSQL seems to be more popular. It has been mentiond 12 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
With this, I went for designing the db. I went to http://drawsql.app/ and created my first draft. Then exported the DDL and did a bit of back and forth with AI. This is the final draft of the database:. - Source: dev.to / 8 months ago
So I started designing the DB using this cool tool. The project has 2 tables, users and categories . The user can create many categories as he wants so the first approach I took was creating a third table, a union table to store user_id and category_id. With this solution the users are able to create x numbers of categories and we can see assign the category to the user. - Source: dev.to / over 1 year ago
Once you have generated the SQL code, you can convert it into a relational schema (the graphical table model) using DrawSQL. This tool offers:. - Source: dev.to / over 1 year ago
DrawSQL makes it easy for teams to collaborate on creating and maintaining schema diagrams. With a single source of truth, there's no need for manually syncing diagram files between different developers and offline tools anymore. Source: about 3 years ago
To be honest, since you are just getting started, I think you should reconsider simplifying this app to begin with. Built something easier and get some more experience before jumping in the ocean. Maybe start by focusing only on the parent company and sub-companies. However, I strongly recommend you to try and make a diagram of your database with relations and columns as it can you a lot of time. I personally use... Source: about 3 years ago
DBDiagram.io - Free database diagrams designer for analysts & developers ๐
Looker - Looker makes it easy for analysts to create and curate custom data experiencesโso everyone in the business can explore the data that matters to them, in the context that makes it truly meaningful.
Azimutt - Next-Gen ERD to Design, Explore and Document real world databases (big and messy ones ^^)
Tableau - Tableau can help anyone see and understand their data. Connect to almost any database, drag and drop to create visualizations, and share with a click.
MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.
Microsoft Power BI - BI visualization and reporting for desktop, web or mobile