PI SQL Commander Lite 4.4

PI SQL Commander Lite by OSIsoft, LLC. is a lightweight, read-only SQL query editor designed for exploring and validating access to PI System data. It connects to the PI System through OSIsoft’s PI SQL Data Access technologies and lets engineers and analysts browse schemas, compose queries, and preview results without needing a full database IDE.

Key features:

• Connects to PI SQL Data Access Server and PI SQL Client (ODBC/OLE DB/JDBC)
• Browses Asset Framework and Data Archive schemas, tables, views, and functions
• Provides a clean editor with syntax highlighting for building and testing queries
• Supports common time-series and event queries, including time-range filtering
• Allows quick ad hoc analysis and result export for sharing or troubleshooting
• Read-only by design, making it safe for use in production environments

Ideal for learning the PI SQL interfaces, validating data access, and accelerating development and troubleshooting workflows, PI SQL Commander Lite helps you get answers from your PI System data using familiar SQL.

PI SQL Commander Lite is developed by OSIsoft, LLC.. The most popular versions of this product among our users are: 4.0, 4.1, 4.2, 4.3 and 4.4. The name of the program executable file is PISQLCommanderLite.exe.