Data Bridge Pro: edit SQL Server data in Excel
An Excel database add-in for people who need to change data, not write SQL. Load a table from SQL Server, PostgreSQL, Snowflake or seven other platforms, edit it in the worksheet, and write the changes back with checks, an audit log and rollback.
Early access means we set it up with you directly. Self-service download and licensing are coming.
Illustration of the change tracking and save step.
From database to Excel and back
Most data fixes that finance and operations teams need are small: a handful of rows, a mapping, a status. Data Bridge Pro lets the person who knows the data make the change.
Connect
Pick your database type and sign in with Windows authentication or a database login. Saved connections are encrypted on your PC.
Load and edit
Load a table or a query result into a worksheet. Edit cells, paste values or use formulas. Changed cells stay highlighted.
Review and save
Preview exactly what will change, then save. Data Bridge Pro validates the rows, takes a snapshot and writes the update in one transaction.
What you get in the Data Bridge tab
Write back to the database
Edit rows in Excel and push inserts, updates and deletes back to the source table, with a preview before anything is written.
Validation
Data types, required fields and key columns are checked before the save, so a typo doesn't reach the database.
Rollback
Each save takes a snapshot of the affected rows first. If a change was wrong, restore the earlier version from the ribbon.
Audit log
Every change is recorded with the user, time, table and before and after values. Export it when someone asks who changed what.
Visual Query Builder
Add tables to a canvas, tick the columns you want, draw the joins and set filters. Data Bridge Pro writes the SQL.
AI Query Assistant (optional)
Describe the data you need in plain English and review the query it drafts. It uses your own AI provider account. What it sends.
Bulk import
Bring rows in from a CSV or another workbook, map the columns to the table, and check them before they are inserted.
Several databases at once
Each worksheet can hold its own connection, so one workbook can work with SQL Server and Snowflake side by side.
Respects database permissions
With read-only access you can load and query data; saving needs write permission. Data Bridge Pro never goes around your database security.
An Excel database add-in for 10 platforms
One add-in for the databases finance and analytics teams use most. No separate connector per database.
Setup guides: SQL Server, PostgreSQL, MySQL, Snowflake, Oracle.
What stays on your machine, and what doesn't
Your data and credentials
- Data Bridge Pro connects straight from your PC to your database. Your data never passes through BridgeStack or Optalytic servers.
- Saved database credentials are encrypted for your Windows account and stored on your machine. You can also choose not to save them.
- Windows authentication is supported for SQL Server, so you can avoid stored passwords entirely.
- The audit log is kept on your machine. You can also choose to write it to an audit table in your own database.
The optional AI Query Assistant
- It is off until you add an API key for your own Anthropic, OpenAI or Azure OpenAI account.
- When you use it, it sends your question, the database type and name, and the table and column names with their data types to that provider so it can draft a query.
- Explain, optimize and filter requests also send the text of the current SQL query.
- It does not send the rows in your tables. Requests go from your PC to the provider directly, not through us.
What you need
- WindowsWindows 10 or Windows 11
- ExcelExcel for Microsoft 365, Excel 2021 or Excel 2019, desktop app on Windows
- .NET.NET Framework 4.8 (included with current Windows)
- DatabaseNetwork access to the server and a login with the permissions you need
- Not supportedExcel for Mac and Excel on the web
From $49 a month
Starter covers SQL Server. Professional adds all 10 platforms, the query tools, audit log and rollback. Team pricing is by quote.
Early access questions
What does early access mean?
Data Bridge Pro is close to feature-complete, but self-service download, licensing and checkout aren't live yet. Early access customers work with our team directly: we get the add-in installed, connect it to your first database and take your feedback.
How do I get early access?
Book a call with our team at Optalytic using the Request Early Access button, or send us an inquiry. We'll talk through your databases and what you want to do in Excel.
Is there a free trial?
Not yet. We plan to offer a self-service trial when we release publicly. Until then, early access is the way to try Data Bridge Pro on your own data.
Is my data secure?
Data Bridge Pro connects directly from Excel on your PC to your database, so your data never passes through our servers. Saved credentials are encrypted for your Windows account. The optional AI Query Assistant sends your question and your table structure, but not your rows, to the AI provider you configure.
Which Excel versions are supported?
Excel for Microsoft 365, Excel 2021 and Excel 2019, using the desktop app on Windows 10 or 11. Excel for Mac and Excel on the web are not supported.
Can I use it with read-only database access?
Yes. You can load tables, build queries and refresh data with read-only access. Saving changes needs write permission on the table.
Do I need admin rights to install it?
It depends on your machine. Data Bridge Pro needs .NET Framework 4.8 and the Microsoft Visual Studio Tools for Office runtime. If either is missing, installing it can require admin rights. We'll confirm what your environment needs during early access setup, including anything your IT team should approve.
What will it cost?
Planned launch pricing starts at $49 a month. See the pricing page for the planned plans. Early access terms are agreed with our team directly.
Try Data Bridge Pro on your own database
Book a call with our team. We'll show you the add-in on a database like yours and set up early access if it's a fit.