A lightweight query profiler for SQL Server and Azure SQL Database — available as a desktop application and as a VS Code extension on the VS Code Marketplace and the Open VSX Registry.
- General Info
- Features
- VS Code Extension
- Requirements
- Authentication Modes
- Supported Platforms
- Known Issues
- Status
- Contributing
- License
- Contact
Light Query Profiler works with Extended Events to collect data needed to monitor and troubleshoot query performance issues in SQL Server and Azure SQL Database. It is available both as a standalone desktop application and as a Visual Studio Code extension.
- Real-time query profiling for SQL Server and Azure SQL Database
- Support for Windows Authentication, SQL Server Authentication, and Azure Active Directory
- Syntax-highlighted SQL query viewer
- Event filtering and full-text search
- Sortable, resizable event columns
- Detailed event inspection with tabbed view
- Cross-platform support: Windows, Linux, and macOS
- Export and import captured events as JSON files for offline analysis and sharing
Light Query Profiler automatically saves your connection settings when you stop a profiling session. Use the Show Recent Connections command to quickly reconnect to a previous server and database without re-entering credentials.
Light Query Profiler is available on the Visual Studio Code Marketplace and the Open VSX Registry:
Install from the VS Code Marketplace
Install from the Open VSX Registry
- Install the extension from the VS Code Marketplace or the Open VSX Registry
- Open the Command Palette (
Ctrl+Shift+P/Cmd+Shift+P) - Run Light Query Profiler: Show SQL Profiler
- Enter your connection details:
- Server name or IP address
- Database name
- Authentication mode and credentials
- Click Start to begin profiling
Captured events can be exported to a JSON file for offline analysis, sharing, or archiving — and imported back at any time without needing an active SQL Server connection.
- Click ⬆ Export... in the toolbar, or use Light Query Profiler: Export Events... from the Command Palette
- Click ⬇ Import... in the toolbar, or use Light Query Profiler: Import Events... from the Command Palette
The exported JSON format is compatible between the VS Code extension and the desktop application.
- .NET 10 Runtime must be installed and available in your
PATH. This is required to run the profiler backend server. - SQL Server 2012 or later, or Azure SQL Database
- The SQL login must have
ALTER ANY EVENT SESSIONpermission to create Extended Events sessions - For Azure SQL Database, at least the
VIEW DATABASE STATEpermission is required
| Mode | Description |
|---|---|
| Windows Authentication | Uses the current Windows user credentials (Windows only) |
| SQL Server Authentication | Username and password |
| Azure Active Directory | Azure AD authentication for Azure SQL Database |
| Connection String | Provide a full ADO.NET connection string. Supports any valid SQL Server or Azure SQL Database connection string. |
The project runs on Windows, Linux, and macOS, provided .NET 10 is installed.
Note: Windows Authentication is only available when running on Windows.
- Windows Authentication is only available when running on Windows
- Azure SQL Database Managed Instance may require additional firewall configuration
This project is actively under development. Stable releases are already available for both the desktop application and the VS Code extension:
- VS Code Extension — available on the VS Code Marketplace and the Open VSX Registry
- Desktop App — available on the GitHub Releases page
Contributions are always welcome — feel free to open an issue or submit a pull request.
Contributions, issues, and feature requests are welcome. Please check the issues page before submitting a new one.
- Fork the repository
- Create your feature branch (
git checkout -b feature/my-feature) - Commit your changes (
git commit -m 'Add my feature') - Push to the branch (
git push origin feature/my-feature) - Open a Pull Request
This project is licensed under the MIT License — see the LICENSE file for details.
Created by Hildebrando Chávez — feel free to reach out!