DataPilot — the SQL Server developer's all-in-one toolkit
Stop juggling a folder full of one-off scripts. Explore objects, trace hidden dependencies, generate code and data, script whole databases, and move data to and from Excel — from one friendly Windows app.
https://postimg.cc/SXw49Frg
If you work with Microsoft SQL Server every day, you know the routine: one query to find a table's columns, another to chase down which procedures call which, a hand-written script to generate test inserts, yet another to script objects for a release, and a fragile copy-paste dance to get data into Excel. DataPilot puts all of that — and a lot more — into a single tabbed window.
It connects to your SQL Server with Windows or SQL authentication and gives you focused, one-click tools for the work developers, DBAs and data engineers actually do. Below is a tour of what it can do.
🔎 Understand any database fast
New codebase? Inherited a database with thousands of objects? DataPilot turns "I have no idea what this does" into answers in seconds.
- 📋 Table Explorer & properties. See a table's columns, data types, lengths, nullability and identity flags — plus primary/foreign-key relationships — without writing a query.
- 📄 Object Definition viewer. Read the full T-SQL of any procedure, view, function or trigger right inside the app.
- 🔢 Indexes & System codes. List indexes for one table or the whole database, and expand system-code lookups with a double-click.
- 🗺️ Database diagram. Export a Graphviz diagram of your foreign-key relationships to visualise how tables connect.
🌳 Dependency analysis — the killer feature
Before you change a stored procedure, you need to know what it touches and what calls it. Most tools (and SQL Server's own legacy dependency views) quietly miss references that are buried inside IF / ELSE, WHILE loops, CURSOR blocks, or dynamic EXEC statements. That's exactly where the nasty surprises hide.
- 🔎 SP Object. For any stored procedure, list every table, view, function and procedure it references — including those used only inside conditional or looping logic.
- 🌳 Reference SP. Build a recursive call tree showing which procedures call which, down through every level. Perfect for impact analysis: "if I change this, what breaks?"
- ✏️ Insert / Update / Delete finder. Quickly locate the statements that write to a given table.
[ Insert a screenshot of the Reference SP call tree here ]
⚙️ Generate code & data
-
⚙️ Generate INSERT statements straight from existing rows, with an optional
WHEREfilter, identity-insert support, and a file mode for very large result sets — ideal for seeding test data or copying rows between environments. -
🔢 Comma-separated value builder. Turn a column of values or a pasted list into a clean, optionally single-quoted, comma-separated string — the fastest way to build an
IN (...)clause. - 🧹 Text utilities to strip whitespace and tidy pasted SQL.
📜 Script databases & move data through Excel
- 📜 Script Database. Generate DDL for tables, stored procedures, views, scalar/table functions and triggers — with options for drops, dependencies, "if not exists" and indexes. Script everything, or just a named list of objects, to a folder.
- 📤 Excel Export. Send query results straight to a workbook; the output path is copied to your clipboard.
- 📥 Excel Import. Load a spreadsheet into a brand-new SQL table in a couple of clicks.
🧰 Built-in developer tools
| Tool | What it's for |
|---|---|
| ▶️ Query Runner | Run ad-hoc T-SQL and view results in a grid. |
| 🔍 Object Search | Find procedures/views/functions/triggers by name or by content. |
| 🔀 Schema Compare | Compare object definitions between two databases. |
| 🧹 Formatter & History | Format T-SQL and keep a history of your queries. |
| 📚 T-SQL & 🔗 SSIS reference | Quick lookups without leaving the app. |
✨ Little touches that save time
- 📋 One-key copy: right-click or Ctrl+C copies an entire results grid with headers, ready to paste into Excel.
- ↔️ Auto-fit grids: columns and rows size themselves to the data every time results load.
- 🖱️ Drag to reorder tabs: arrange the tabs the way you like — your layout is remembered next time.
- 😀 Emoji-labelled tabs make the busy toolbar easy to scan at a glance.
🔐 Built for teams & vendors
👥 Users, roles & tab access
Create users and roles and decide which tabs each role can use. Passwords are securely hashed (PBKDF2), accounts lock after repeated failures, and there's self-service forgot/reset password with one-time codes plus admin resets. Accounts live in your own SQL Server.
🔑 Rental or perpetual licensing
Offline, machine-locked keys support both time-limited rentals and perpetual sales. A 14-day trial is built in, and keys are cryptographically signed so they can't be forged or shared between machines.
👥 Who it's for
| Role | Why they'll love it |
|---|---|
| SQL developers | Dependency tracing and code/data generation cut the boring parts of every change. |
| DBAs | Scripting, index listing and impact analysis in one place. |
| Data / ETL engineers | Excel import/export and quick lookups speed up data wrangling. |
| Analysts | Browse data and copy clean results to Excel without SQL gymnastics. |
❓ Frequently asked questions
What do I need to run it?
Windows with .NET 8 and access to a SQL Server instance (2016 or later). Connect with Windows or SQL authentication.
Does it change my database?
The tools are read-and-generate by default. The optional security feature creates a few small DataPilot_* tables only if an admin chooses to turn it on.
Is my data sent anywhere?
No. DataPilot runs locally and talks only to the database you connect to. Licensing is offline too.
Can I try before buying?
Yes — a 14-day trial is built in.
Ready to work faster in SQL Server?
Try DataPilot free for 14 days, or talk to us about rental and purchase licensing for your team.
Request your trial / pricingDataPilot · SQL Server 2016+ · Windows · .NET 8