Integrations / SQL Server

Connect

SQL Server

with ToolJet

Connect SQL Server to ToolJet to fetch, visualize, and manage data in real-time, perfect for dashboards, reporting tools, and workflow automation.

Docs

Available actions with ToolJet and SQL Server integration

ToolJet's integration with SQL Server supports various operations:

Establish a connection

Connect ToolJet to your Microsoft SQL Server or Azure SQL database using host, port, and authentication credentials. For Azure SQL, simply toggle the Azure option and configure encryption for added security. Optional connection parameters like trustServerCertificate allow secure self-signed SSL configurations.

Query SQL Server

Run raw SQL queries directly from ToolJet’s editor using SQL Mode. ToolJet supports parameterized queries to prevent SQL injection and allow dynamic filtering using variables.

Update records

Use GUI Mode to perform bulk updates using the primary key. Provide records in an array format and update multiple rows in a single action—ideal for admin panels and internal tools.

Use parameterized queries

Add dynamic behavior to your SQL queries by defining parameters like username and binding them to component values or inputs via {{ }}. This makes your queries secure and responsive to user interactions.

Customize timeout settings

Control query performance by setting execution timeouts with the PLUGINS_SQL_DB_STATEMENT_TIMEOUT environment variable. The default is 120,000 ms.

Transform query results

Post-process query results using JavaScript transformations directly within ToolJet, enabling real-time formatting, calculations, or filtering before rendering the data.

Why use ToolJet with SQL Server

AI-powered app building

Build internal tools, workflows, and AI agents in hours using plain English. Go from idea to production with AI-generated apps, data models, and instant debugging.

Enterprise-grade security and compliance

Stay secure with SSO, RBAC, audit logs, encryption, and compliance standards like SOC2, ISO 27001, and GDPR. Deploy your way: cloud, on-prem, or hybrid.

Production-ready database and integrations

Skip setup hassles with instant PostgreSQL and pre-built integrations for AI, databases, storage, and APIs.

Components and environment management

Speed up development with 60+ pre-built components and manage releases across dev, test, and production environments.

Flexible development options

Use no-code visual builders, or dive into low-code, and switch seamlessly as your needs evolve. You have full control, and there is no lock-in.

JavaScript and Python

Write custom logic and data transformations using JavaScript or Python, flexible scripting built right in.

Explore more Database integrations

Frequently asked questions

1. What is SQL Server Management Studio (SSMS), and how does it relate to ToolJet?

⌄

⌃

SQL Server Management Studio (SSMS) is Microsoft’s official GUI tool for configuring, managing, and querying SQL Server databases. While SSMS is great for database administration, ToolJet provides a no-code/low-code alternative for building internal tools on top of SQL Server without writing full applications.

2. Can I use SQL Server Integration Services (SSIS) with ToolJet?

⌄

⌃

Yes, you can complement your SQL Server Integration Services (SSIS) workflows with ToolJet. While SSIS is focused on ETL processes, ToolJet connects directly to your SQL Server to visualize or manipulate data post-integration. You can even connect SSIS output tables to dynamic dashboards in ToolJet.

3. Is ToolJet compatible with SQL Server 2019 and SQL Server 2022?

⌄

⌃

Absolutely. ToolJet supports connections with SQL Server 2019 and Microsoft SQL Server 2022. Whether you're using SQL Server Express for lightweight apps or enterprise-grade deployments, ToolJet allows secure querying and updates via both versions.

4. How do I download SQL Server 2019 for use with ToolJet?

⌄

⌃

You can download SQL Server 2019 from the official Microsoft website. Once installed, configure your database settings and use ToolJet’s data source configuration panel to connect using your host, port, and credentials.

5. Can I build reporting tools similar to SSRS using ToolJet?

⌄

⌃

Yes! ToolJet allows you to build interactive dashboards and reports, similar to SQL Server Reporting Services (SSRS). You can write queries or use GUI mode, bind them to visual components, and even trigger updates based on user input—all without complex coding.

6. Does ToolJet support SQL Server Integration Services Projects from Visual Studio 2022?

⌄

⌃

While ToolJet doesn’t directly edit SSIS projects, it integrates smoothly with databases that are part of SSIS pipelines. You can use ToolJet to display, monitor, and manipulate data that’s handled by SSIS projects built in Visual Studio 2022.

7. What are the pricing considerations when using SQL Server with ToolJet?

⌄

⌃

SQL Server pricing depends on the edition—SQL Server Express is free, while Standard and Enterprise editions require licensing. ToolJet connects to any edition, so your integration cost will primarily depend on your SQL Server license and whether you use ToolJet Cloud or a self-hosted deployment.