Schema, relationships & data in your browser.
~ ~ ~
Learn. Explore. Document. Share.
I know you're skilled with databases but time is tight on the project and getting to know the database is time not shipping.
I want to help, so I've built a new tool called Sql Schema Explorer which helps you understand a database faster than ever.
It's not quite like any of the other tools out there. You use it through your browser, but it runs locally so you don't have to worry about your data escaping to the internet. When you need to know what foreign keys a table has it's just one click in your browser, you can even click through related rows of data to see how everything fits together.
It's open source and there's a free download with no missing features so you can try it out on your own machine with the database you are working on. Once you've fallen in love with it I'm sure you'll add it to the arsenal of SQL tools that make you the pro you are.
I think you should definitely try out Sql Schema Explorer with one of your own databases, I think you'll wish you'd had it years ago.
If you like this you might like the other things I do over at timwise.co.uk. I do custom software development and contract work so do reach out if you would like to work together.
How it works
SQL Schema Explorer creates a dynamic website visible only to you that gives you effortless access to the tables, relationships and data in your database.
Simply download SQL Schema Explorer, run it on your pc and connect it to any database.
See it in action
Wow, the tool was superfast, and did the job without any hiccups. A few arrangements of the entity boxes + and some manual panning and zooming - and voila an ER diagram. Kudos to you!
~ Frank Gynnild - Advocate of DDD & TDD. Software Architect. High Scalability. @VirtualIndex
This is freaking awesome, this'll make learning this schema SOOO much easier.
~ Andy Brook, Software Solutions Architect & SQL Database Specialist, Canada
SQL Schema Explorer is (now) open source, you can view and contribute at https://github.com/timabell/schema-explorer.
Email: firstname.lastname@example.org - feedback welcome!
Contribute to the direction of the product on the public product roadmap.
Join the Facebook group SQL Schema Explorer Users on Facebook.Help spread word of the new tool by sharing a tweet about schema explorer.
Read and share the blog posts and articles from SQL Schema Explorer.
Hi, I'm Tim Abell. I've worked as a professional programmer focussing on Microsoft ASP and SQL Server for the last 18 years.
I have seen many different databases in that time, some easier to get around than others. My experience of databases is from the perspective of having to do something with them beyond just using them, be that migrating them to a new system, writing code on top of them, or modifying the databases themselves.
Ever since my first job out of university working with Microsoft ASP Classic and SQL Server '97 I've felt that it was unreasonably difficult to get the information I wanted about a database. I've created SQL Schema Explorer to be the solution to this pain that will be there to help you and many others like you for many years to come.