Database tools I was surprised existed

But you already know all the tools for working with databases don’t you?

That’s what I thought too before I started working on SQL Schema
Explorer. Even after 18 years working with
databases it turns out I only knew a fraction of the tools that are out there.

Working on SQL Schema Explorer gave me a reason I didn’t have before to search
the internet in new ways relating to databases, and now that I’m reaching out
to people about SQL Schema Explorer people are in turn sharing their favourite
tools with me.

I’d hate for this gift to sit hidden away in my private product trello board,
so I’ve turned it into this article so that you can skip the wilderness years
and gain a zen-like awareness of all the tools of your trade. I’m sure you
won’t like or use all of them, and many overlap in function, but the following
list will allow you to try out and asses each one against your needs; perhaps
you’ll find a new tool that will save you hours, or make your job that much
more enjoyable. Never again will you have to say to a new colleague “oh I
hadn’t heard of that one!”.

Cross-database

Razor Sql

“RazorSQL is an SQL query tool, database browser, SQL editor, and database
administration tool for Windows, macOS, Mac OS X, Linux, and Solaris.
RazorSQL has been tested on over 40 databases, can connect to databases via
either JDBC or ODBC”

Information overload

If you got this far you probably need to get back to work. It’s clear this
article is a bit ridiculous now so I’m not going to carry on sorting it out.
The internet is littered with catalog articles of varying completeness and
quality. To make it complete and good would make it dull and endless.

Watch this space, I think I’ll try and work out what people actually are trying
to do and cater for that. Maybe we can all build a collaborative index
somewhere.

The end

I hope you found at least a few you didn’t know about and that they make your
life better in some way. Please do tell me the story of how this helped you on
email or twitter.
Did I miss something? If you wish to improve this article please ping me a PR
with additions here: https://github.com/timabell/sdv-website or just email
me.

I’m not being paid to promote these, these are not affiliate links, I share
this learning with you all for free so that we can all enjoy our work with
databases more, and create better more reliable databases for ourselves, our
clients and our projects.

If you want to be notified of new articles, sign up to the mailing list (which
currently is also the trial download list).