Bookmarks
Choose a title for this bookmark.
Bookmark saved
| Developer: | Data Prudentia (1) | ||
| Price: | * Free New | ||
| Score: | 1,090 Silver | ||
| Rankings: | 0 | ||
| Comments: | 0 Add a comment | ||
| Lists: | 0 + 0 | ||
| Points: | 0 + 0 ¡ | ||
| +1 Points | |||
Screenshots
Advertisement
Description
It connects to virtually any database, but it is not just another generic SQL tool: SQL Data Lens understands the InterSystems data model. Classes, globals, routines, namespaces and SQL objects are all available in a single, fast workspace — no switching between Studio, terminal and a third-party query tool.
WHY SQL DATA LENS
- Built for InterSystems. Browse and analyse class definitions, globals and SQL metadata the way they are actually structured.
- One workspace for everything. Servers, connections, queries, results and scripts stay organised in a single window.
- Fast where it matters. Large result sets, deep global trees and complex schemas stay responsive.
- Works with the rest of your stack. Additional databases can be queried side by side and combined locally.
KEY CAPABILITIES
Connection management
Organise servers, namespaces and credentials in a clear tree. Switch environments in a click and keep development, test and production visually separated.
SQL query editor
A fast editor with syntax highlighting, code completion, formatting, execution plans and multi-statement execution. Export results to CSV, Excel or JSON.
Table viewer
Inspect, filter, sort and edit table data directly — including quick filters, column search and in-place editing without writing UPDATE statements by hand.
Class viewer
Explore InterSystems classes, properties, methods, indices and relationships, and see how they map to the underlying SQL tables.
Global viewer
Analyse the internal data structures behind your data. Navigate global nodes, inspect subscripts and values, and understand what is really stored.
Local query cloud
Combine data from different sources in one local query — useful for comparing environments or joining data that lives in separate systems.
Script manager
Store, organise and reuse your scripts and snippets so recurring tasks are one click away instead of buried in a folder of .sql files.
WHO IT IS FOR
- InterSystems developers who want a modern, responsive alternative to the built-in tooling
- Database administrators maintaining IRIS and Caché installations
- Analysts and integrators who need reliable read access and fast exports
- Teams migrating, comparing or documenting existing InterSystems systems
GETTING STARTED
Install, add your first server connection, and you are querying within a minute. No server-side installation or configuration is required.
Questions, feature requests or feedback are always welcome, see the support link on this page.
Other platforms
| SQL DATA LENSWindows StoreYou are hereIn-App Purchases | Free |
Only in this store right now.
Price History
- Current price: Free
- Minimum: Free
- Maximum: Free
Track prices Add to a list to get discount alerts by email or push
Lists (0)
0
- SQL DATA LENS
Points (0)
0
Rankings (0)
0
Comments (0) ¡
Be the first to comment
Developer
- Data Prudentia
- Followers: 0
- Platforms: Windows Apps (1)
- Deals: 0
- Lists: 0 + 0
- Points: 0 + 0 ¡
- Rankings: 0
- Comments: 0
- Videos: 0
- RSS: Subscribe
What's new
- Version: 4.01
- Last Updated:
- Version 4.01 — a major release. 137 changes since 3.24.
NEW
- Azure SQL and Microsoft Fabric — an Azure tab that asks how you sign in: SQL login, Entra ID token, or the az login you already have.
- Encrypted connections — a TLS tab on every connection, plus an assistant that fetches the server certificate, writes the trust store and tests it. No keytool, no restart.
- Stored passwords protected by Windows DPAPI, bound to your Windows account. A copied config file no longer gives them up.
- Classify connections as Development, Test, Production or Failover, and put a read-only guard on the ones nobody should write to.
- Source code search across a whole namespace, server-side, plain text or regex — plus "Where is this used?" from any table.
IMPROVED
- Query Cloud now federates: join IRIS, PostgreSQL and a CSV folder in one statement, with filters pushed into each source.
- IRIS execution statistics in the editor — global references, disk reads and their latency — and a searchable SQL History.
- The SQL Scanner reports unindexed foreign keys on IRIS and Caché, and reads the server's own execution plans.
- Execution plans are readable text; SQL Server, PostgreSQL and DuckDB deliver them too.
FIXED
- Class operations and Terminate Process work on IRIS again.
- Excel workbooks are queryable; CSV export quotes correctly.
- Withdrawn drivers with known CVEs are removed on every start.
Full release notes: sqldatalens.com/whats-new/
Additional Information
- Release Date:
- Category:
Windows Apps›Developer tools - OS:
PC - Supported Languages:
English - Content Rating:
EVERYONE - Windows Store Rating: ¡
0 - Website:
https://sqldatalens.com/
AppAgg Score
1,090
Estimated AppAgg Score for
SQL DATA LENS
Developer: Data Prudentia
1,090 Silver
Higher scores usually reflect better results across AppAgg’s indicators.
Based on: popularity · ratings · freshness · deals · store data · community signals
Recalculated daily using fresh AppAgg data.
Website badge: 
Copied!
Summary
SQL DATA LENS Short URL: Copied!- Windows Store
On AppAgg, you can track the Windows app “SQL DATA LENS” by Data Prudentia, listed under Developer tools. AppAgg Score: 1,090 (Silver). AppAgg Points for the app — confirmed: 0; indirect: 0. Public lists containing the app: 0. Users who have saved it in private lists: 0. AppAgg users have not rated the app yet. Confirmed Points record visits to a store by signed-in AppAgg users; indirect Points are based on store data. AppAgg counts public lists containing an app or game and users who have saved it in private lists. The app was first released on . The app was last updated on . The app is currently available for free. The app is available in these languages: English. Explore the price history, add the app to a list, or follow its developer. Follow future deals and updates for the app via its RSS feed. AppAgg does not host or distribute the app. All trademarks, logos, and screenshots related to the app belong to their respective owners.
You may also like
Recent discussions
AppLocalDub – Real-Time Game Dubbing Hello Kırtay Interactive, I am using LocalDub - Real-Time Game Dubbing. I would like to know if Hind... 
rashid game5 
AppNauticPlayer This app is absolute cinema. Honestly, it’s one of the best media players I’ve ever tried, and I’m s... 
Manuel16 
AppScreen Beings - Desktop Pet & Study Companion This is my app so I’m a little bias but as someone from the ADHD community that teaches ADHD and neu... 
Tarelle Irwin6 
AppAadi vault good it ia a encrypter and good you my work on office 
Aditya Rai5 
AppTyping 365 | Daily Typing Trainer The best typing app ever. With Typing 365 you don’t have to force yourself for couple minutes traini... 
Ahmad Mozaffar5 
AppZefir Calendar — Calendar in the Taskbar excelente app! Superando todas as espectativas! 
Diógenes Magnus5 
AppLockinRa LockinRa 리뷰 LockinRa는 작업 관리, 집중력 도구, AI 코칭을 하나의 데스크톱 앱으로 통합한 무료 Windows 생산성 프로그램입니다. 클라우드 동기화 없이 로컬 ... 
abhilok reddy6 
AppCN Vault I Love this app CN Vault is a user-friendly app that helps keep your passwords safe and secure. If y... 
Marjuk Amin5 
