A VS Code extension for Adhoc SQL query with advanced result visualization and analysis features.
Designed to work in conjuntion Microsoft's MSSQL extension (re-use existing connections) - think of it as a re-skin. Additionally, you can configure your own connections independently (supports SQL Server and PostgreSQL) without using mssql, but this extension does not come with its own language server.
Execute multiple queries simultaneously and view results in separate tabs with ability to cross-compare. For example, compare SQL Server data with PostgreSQL data.
Modern interface that improves upon the standard MSSQL extension:
- Clean, responsive result tables. One tab per dataset
- Column grouping, global filtering, resizing and sorting
- Export capabilities: Excel, CSV, Markdown, Data Wrangler
Auto generate queries based on selected data points to explore related information quickly.
- VS Code 1.99.1 or higher
- For SQL Server: .NET Runtime 10.0 or higher
- Azure SQL Active Directory Interactive authentication requests SQL-resource tokens from VS Code's Microsoft sign-in, reusing an existing session when possible and prompting for sign-in or consent if needed. Active Directory Default uses the .NET credential chain.
Contributions are welcome! Please feel free to submit a Pull Request.
MIT License