idxScout - Database Discovery, Machine Assisted SQL and Easy Modeling with a free 30 day trial. 2.0.0 is a Major upgrade.
Do relational databases have to be so complicated, so hard to understand? Well, idxScout is the answer you've been waiting for. It investigates relationships hidden deep within a relational database, revealing its logical structure. You'll see a uniquely different and a much better way to analyze your database. Whether you're a pro or a novice, or the database is simple or complex, you'll be writing database queries (SQL) with machine assisted accuracy, giving your brain a break.
A modern database may contain hundreds of tables, each with ten or more fields, resulting in a matrix of thousands of individual parts. Learning it can take days for professionals and weeks for novices. If the database has no documentation, you may never fully grasp its complexities.
idxScout is the answer to this 'information gap'. It features a Key Hunter which hunts through the database and finds foreign keys. You'll see flaws, missing indexes, duplicated data and structural defects immediately. Data models are easier to understand than graphic-based systems. Indexes and primary keys are highlighted; see them with a glance.
Write SQL select statements fantastically fast. Just check and choose the tables and fields you want to query. Gone are the days when it was easier to select all fields (*) from a table. Press CTL-S to look at the data, select it if you want it, press preview and check it off your to-do list.
Let your machine help you build SQL joins. idxScout has the intelligence to predict foreign key joins for you. If the join is complex, pick from a list of relationships. Move the order around with a click. Eliminate frustration and save your brain for better tasks. You'll see joins that are always straightforward, never nested, never confusing, and easily understood.