SQLdep joins Collibra to build the future of Data Lineage Learn more

Automated Data lineage for SQL

In 10 minutes we document 10 years of your development.

Computer screen displaying SQL code Computer screen displaying SQLdep vizualization
See demo
Our products
for single query
  • Great for individual developer or BI analyst
  • Diagrams with table joins
  • Interactive SQL code highlighting
  • Quick list of all used tables and columns
for multiple queries
  • Enterprise solution for BI/DWH teams
  • End-to-end data lineage
  • Team management and secure sharing
  • Metadata and data lineage import/exports

Why data lineage

Risk prevention

”SQLdep reduced number of incidents caused by overlooked dependency during ETL development by 20%.”

Reduce vendor dependency

”SQLdep helped us to mitigate the risk of vendor lock-in. Any change in ETL made by vendor is now automatically documented and know-how is kept in house.”

Regulatory requirements

”SQLdep provides insight of all data flows in DWH and prepares output for auditing.”

”We tremendously accelerated the development cycle and incident management in our data warehouse.”

Teradata logo
PostgreSQL logo
Microsoft SQL Server logo
Oracle logo
Redshift logo
Snowflake logo
Greenplum logo
Spark logo
Netezza logo
Hive logo
Impala logo
DB2 logo
MySQL logo
SAP Hana logo

Compliance with GDPR, BCBS 239, HIPAA


  • Mark columns with sensitive data & track them in the DWH
  • Audit trail for all data transformations
  • Have automated reports with end to end data lineage


Mission: Capture the context to avoid meaningless data

Show more
  • No conflicts between reports done by different departments
  • Data stewards & analysts share knowledge among the teams
  • An automated overview of any change impacting the data


Mission: Innovate our technology stack

Show more
  • Detect unused columns and optimise DWH
  • Decrease number of incidents due to overlooked dependencies
  • Faster on-boarding of new team members

How it works

Upload SQL code
SQLdep extracts data lineage
Browse / import

Our features

Automated data lineage

Our reverse engineering algorithm transforms SQL code into an interactive map with end-to-end data lineage. Supported are all major database vendors and procedural code. A must have for legacy SQL code.

Metadata / Documentation Export

All metadata can be downloaded as a CSV file or directly through our API. Exports to PNG or PDF formats are available along with embedding our UI into your existing metadata platform.

Team management and Secure sharing

With team management you can easily invite your colleagues and share the documentation with them. Your documentation is protected by multiple layers of security with on option to flexibly manage the access.


SQLdep primarily runs as a cloud based service. No hardware needed, no installation needed. Everything runs in your browser out of the box. To interact with our service use REST API or our neat User Interface.

Tracking changes in the data lineage

Visually compare the changes within the data lineage across different environments, like staging versus production. Or compare how the data lineage differs in time based on your auditing requirements.

Highlighting relevant parts of SQL code

Quickly navigate through SQL code including subqueries. SQLdep provides simple user interface to browse the data lineage and show you relevant parts of SQL code. Highlighting is in place to save time of your engineering team.

Tech section

What SQL syntax is supported?

Any valid SQL query regardless its complexity (with clauses, nested subselects, analytical functions, etc.).

Part of my lineage is in SQL and while the rest is buried elsewhere like Informatica, SAP, etc.

Get in touch with us. We will let you know whether we can help you with that.

How to automate uploads?

We recommend to use our REST API or our downloadable app and schedule the uploads.

Can I import lineage from SQLdep into a 3rd party metadata tools?

Of course, either use our existing integrations or a dedicated developer will help you with it. Your subscription fee covers this.


SQLdep is trusted by large enterprise customers across Europe and United States. See high level platform Security overview [PDF]. SOC type 2 report is available to your IT Sec team per request.

What happens if I upload an unsupported SQL syntax?

We guarantee to support any valid SQL syntax used by our paying customers. In case this happens we will work on it right away. About 95% of such occurrences are resolved within 2-3 days.

Can you help me with *something* during my trial/PoC?

Absolutely! Use the chat icon in bottom right corner in your dashboard.

Features roadmap

Tracking changes in the data lineage

You can visually compare the changes between the lineage across different environments like staging versus production. Or you can compare how the data lineage differs before and after the release on production. That also comes in handy if guys from the audit department stop by and start asking questions on how the data were calculated 2 months ago. You are a couple of clicks away to give a precise answer.


Google login and team management

With team management you can easily invite your colleagues and share the documentation with them. Your documentation is safe with us and any new user needs to be authenticated first. For your convenience we have also added login through Google accounts.


Tracking data lineage across multiple databases

Tracing data lineage manually between multiple databases is a complete nightmare. At SQLdep we automatically trace your data flows between any number of data marts or intertwined data warehouses. Support for database links is included as well.


Exports into CSV files

We compute the metadata and provide you with neatly done visualisations. Yet you might find helpful to download such metadata in textual form. You can perform your own ad hoc analysis or even further optimise your ETL processes. It is also very helpful when you have existing documentation and you need to verify it against actual code.


Complete impact analysis

Full impact analysis gives you instant and thorough view on any change you need to make in your data warehouse. Not only it saves your developers' time it also prevents the risk of them omitting any dependency. This includes all query clauses like WHERE, ORDER BY, GROUP BY.


Increasing data quality

Whenever you encounter problem with the corrupted data you need to immediately understand what reports have been affected. This feature allows for interactive search based on the actual data and values. Thus giving you the right tool for improving data quality.


Data Glossary: users can place and share comments about the data

Metadata management is about empowering you and your users with an option to describe your data lineage / flow. For example product profitability calculations are among the most complex within the company. Any user can now place a comment and explain any transformation which is then easily shared among the team.


Snowflake SQL dialect

Snowflake is a optimised database for Data Warehousing and it runs in cloud. SQLdep has complete support for SQL syntax used in Snowflake DB.


Integration into IBM InfoSphere Catalog

Automated integration with IBM metadata repository allows you to consolidate lineage from multiple sources.


Collibra integration

Tight integration with Collibra will ensure you have consolidated lineage. Using SQL in your infrastructure won't be a blind spot anymore.



SAP HANA is an in-memory, column-oriented database. Enjoy automated lineage extraction from its SQL syntax.


Single sign-on (SSO)

Login to your computer and your credentials won't be needed to gain access to our site.


Integration with Informatica Metadata Manager

Tight integration with Informatica Metadata Manager will result into a consolidated lineage. Using SQL in your infrastructure won't be a blind spot anymore.



Vertica is a column based database designed to manage fast-growing volumes of data. Complete SQL syntax support within scope.


SQL Server Management Studio (SSMS)

Lineage extraction from SSIS packages and optionally enriched with lineage from SQL scripts.

Q3 2019


BigQuery and SQL like syntax used in Google's enterprise data warehouse product.

Q3 2019

Let us handle your lineage

Photo of Martin
CEO / Sales / Founder
Photo of Mirek
CTO / Developer / Founder
Photo of Ondra
Photo of Tom
Photo of Paul
Photo of Tom
Photo of Peter
Photo of Joe