Your SQL Server Database, Finally Visual
McSaver Searcher is a visual query builder and database analysis studio. Build SELECTs without writing SQL, chart any column, hunt down orphaned records, and find every view or procedure that quietly stopped working — all by pointing and clicking.
Rate Your SchemaSix visual tabs across the whole database
See It in ActionThirteen real screens, live sample data
Base & ProFrom $29.99 · one-time purchase
Point & ClickBuild queries without writing SQL
Schema DiagramEvery related table and key, drawn for you
Dependency GraphSee what an object uses, and what uses it
Everything You Need to See Your Database Clearly
Visual Query Builder
Click tables, columns, filters, and joins. Watch the SQL build itself and results stream in. Supports aggregates, ordering, ranking, window functions, and expressions — without typing a SELECT.
Table Editor & Live Charts
Excel-style filtering and sorting on any table. One click turns a column into a chart so outliers and skew jump out — eleven chart types, no export needed.
Orphan Finder
Scan every foreign key for child rows whose parent is gone. Generate transactional cleanup scripts with row-count guards that roll back on mismatch — safe by default.
Database Analyze
Score your schema against best-practice rules — missing keys, naming, indexing, documentation. Auto-generated T-SQL fixes come ready to review and run.
Broken-SQL Validator
Validate every view, stored procedure, and function against the live schema. Surface the ones that no longer compile before your users find them.
Investigate & Data Chain
Drill into column usage, distinct value distributions, and dependencies in both directions. Build dependency-ordered delete chains that respect every foreign key — fully transactional.
Write SQL by Clicking, Not Typing
Pick a root table, check the columns you want, drag conditions into groups, and McSaver Searcher writes the SELECT for you — joins, GROUP BY, window functions and all. The generated SQL and the results update as you go.
- Tables, joins, filters, aggregates & ordering — visually
- ROW_NUMBER, RANK, LAG/LEAD, percentiles & expressions
- Save as criteria, SQL, view, procedure or function
How a Query Comes Together
Build it by pointing and clicking, watch the SQL write itself, then get answers — no hand-coding at any step.
Pick Columns & Aggregates
Choose output columns and add COUNT, SUM and AVG visually — here, product category and product name with order quantity and line-total rollups.
The SQL Writes Itself
Joins, GROUP BY, HAVING and ORDER BY are generated for you from the choices above — review or edit the raw T-SQL any time.
Run & Get Answers
Execute and page through real results — 266 product categories here, each with its order count and summed line total.
Window Functions & Expressions, Built Visually
On the Select tab, the dictionary icon on any column opens an advanced editor — ranking, windowed aggregates, percentiles, offsets, and free-form expressions — so you get the power of OVER() and computed columns without writing the syntax.
Ranking
Number or rank rows within a partition — ROW_NUMBER, RANK, DENSE_RANK — ordered however you choose, without collapsing the rows. Ideal for "top N per group" and leaderboards.
Window Aggregate
Run SUM, AVG, COUNT, MIN/MAX OVER() a partition, so every row keeps its detail and shows the group total beside it — running totals and percent-of-group made easy.
Percentile
Report medians and percentiles — PERCENTILE_CONT or PERCENTILE_DISC — within an ordered group, so you describe the middle of the distribution, not just the average.
Offset
Compare each row to its neighbours with LAG and LEAD — pull a value from a prior or following row, with an offset and a default, for period-over-period change.
Expression
Write a free-form formula like @0 * @1 / @2 and map each placeholder to a column — calculated columns, ratios, and CASE logic that live in the query, not a downstream spreadsheet.
From Query to Chart in One Click
Pick two columns, choose a type, and the Charting Window draws it instantly. No export, no spreadsheet, no pivot dance — your result set becomes a chart right where you searched.
Define your charts once. Then run — and rerun — the same set with the latest data whenever you need it, without touching the selection criteria. A couple of clicks refreshes every chart at once, ready to print.
Single Series, Instantly
One column on X, one on Y — that's a chart. Bucket, summarize, and relabel inline, then flip between Bar, Line, Area, or Pie without re-running the query. The shape of your data shows up before you finish thinking about it.
Multiple Series, Just as Fast
Add more series and compare them side by side on the same axes — grouped bars, layered lines, stacked areas. Color, legend, and scaling are handled for you, so a multi-series comparison is the same one click as a single one.
Eleven Chart Types in the Type Dropdown
Go Beyond Building the Query
Inspect how SQL runs, then find the code you need across the database — all from focused windows inside McSaver Searcher.
Run SQL. See what SQL Server sees.
Work with custom T-SQL in a syntax-highlighted editor, then switch between results and execution-plan views without leaving the query. Review estimates before a run, or measure actual behavior after it.
- Inspect estimated operators, costs, and missing-index suggestions before execution.
- Measure actual rows, CPU time, and elapsed time; data-changing SQL prompts first and the run is rolled back.
- Review tuning suggestions and candidate index SQL beside the query plan.
- Keep query history and save an actual plan as a
.sqlplanfor SQL Server Management Studio.
Find the SQL buried in your database.
Search object definitions across the database instead of opening views, procedures, functions, and triggers one at a time. Finder lists matching objects and takes you to the hit in the source editor.
- Search for a literal phrase or use regular expressions for more targeted patterns.
- Ignore case when capitalization varies across object definitions.
- See matching object types and names together, then open the source at the matching line.
Schedule Queries for Later
Set a date and time, add an optional note, and let McSaver Searcher run the current query or selection when the countdown reaches zero.
Set it up once. Come back to the result.
Schedule a query for a specific date and time from the Query Window. The live countdown keeps the pending run visible, with an Abort control if plans change. When it finishes, Searcher reports the completion and runtime in a desktop notification.
- Choose the run date and time, with quick adjustments for +1, +5, or +15 minutes and +1 hour.
- Add an optional note to recognize the scheduled task later.
- Track the countdown and abort a pending run before it starts.
- Get a desktop notification when the scheduled query completes, including its run time.
Score Your Schema at a Glance
Domain-knowledge and design ratings break down across tables, columns, keys and indexes — and climb as you fix things.
Chart Any Column on the Fly
Bucket, summarize and plot value distributions instantly to spot outliers and skew — eleven chart types, no export needed.
Browse and Edit Any Table
Excel-like filtering and sorting on every column, with natural-key info and one-click foreign-key navigation left and right.
Find Every Best-Practice Gap
Integrity, quality, naming and documentation rules scored across the whole schema, each with generated T-SQL fixes.
Hunt Down Broken Relationships
Scan every foreign key for child rows whose parent is gone, then generate safe, transactional cleanup scripts.
Catch What Stopped Compiling
Validate every view, procedure and function against the live schema — surfaced in seconds, before your users find them.
See What References What
Drill into a column's usages, discrete value distribution and every dependency — in both directions across the database.
Delete in the Right Order
Build transactional, dependency-ordered delete scripts that respect every foreign key — a record and all that hangs off it.
Query Without Writing SQL
Pick predicates, run, and page through results — thousands of matched rows, no code required.
Navigate the Relationships
Browse the schema as a tree — pick any table and see what it links to on the Left and Right of the join path, then re-root your query on any of them.
Document It in Place
Manage extended-property descriptions, to-dos and aliases that flow back into tooltips and your generated queries.
See How Your Tables Connect
Pick a table and its related tables are drawn with every column, data type and foreign key — one hop out or the whole database. Hover a line to see the columns it joins, then open any table straight in Searcher.
Know What a Change Will Touch
Pick any object to see what it reads from on the left and what depends on it on the right, as many levels out as you choose. Double-click a box to re-center on it, or right-click to view its definition.
We Care About What You Think
Built right into McSaver Searcher — paste a screenshot, drop us a note, attach your schema if it helps. We read every message, and the next release ships from real user feedback.
