Registry / database / n8n-nodes-stream-csv-from-microsoft-sql

n8n-nodes-stream-csv-from-microsoft-sql

library1.1.2jsnpmunverified

An n8n community node (v1.1.2, latest) that connects to Microsoft SQL Server, executes a SELECT query, and returns the result as a binary CSV file. It is designed for streaming large result sets (millions of rows) without exhausting memory, using temporary file-based buffering. This differentiates it from in-memory CSV converters and allows handling of large exports within n8n workflows. The node adds execution metadata (row/column count, file name) to the output JSON. It requires the `n8n-workflow` peer dependency and uses the built-in Microsoft SQL credential type. The package is maintained irregularly by a community contributor.

database devops

npm install n8n-nodes-stream-csv-from-microsoft-sql

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · N8N-NODES-STREAM-C

n8n-nodes-stream-csv-from-microsoft-sql

databasejavascriptv1.1.2

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

MicrosoftSqlToCsv

✓ import { MicrosoftSqlToCsv } from 'n8n-nodes-stream-csv-from-microsoft-sql';

✗ const MicrosoftSqlToCsv = require('n8n-nodes-stream-csv-from-microsoft-sql');

ESM only; CommonJS require() will fail at runtime.

microsoftSqlCsvApi

✓ import { microsoftSqlCsvApi } from 'n8n-nodes-stream-csv-from-microsoft-sql';

✗ import microsoftSqlCsvApi from 'n8n-nodes-stream-csv-from-microsoft-sql';

Named export, not default.

MicrosoftSqlToCsv

✓ import type { MicrosoftSqlToCsv } from 'n8n-nodes-stream-csv-from-microsoft-sql';

TypeScript users should use type import for type-only usage.

Shows how to import and use the node class programmatically; node is primarily used via n8n UI.

// In an n8n workflow, add the 'Microsoft SQL to CSV' node. // The node will execute the query and output a binary file. // No custom import code is needed within n8n. // To demonstrate programmatic use (e.g., in a custom node): import { MicrosoftSqlToCsv } from 'n8n-nodes-stream-csv-from-microsoft-sql'; const node = new MicrosoftSqlToCsv(); // Use node.execute() with appropriate context

Debug

Known issues

gotchaNode intentionally fails if query returns multiple recordsets.

fix

Ensure your SQL query returns a single result set.

affects: >=1.0.0

gotchaSQLITE_BUSY/database is locked errors are caused by n8n's persistence layer, not this node.

fix

Reduce concurrent execution load, enable execution data pruning, or update n8n.

affects: >=1.0.0

gotchaVery large exports may still cause memory pressure if Include Input JSON is enabled.

fix

Disable Include Input JSON when not needed; minimize upstream fields.

affects: >=1.0.0

Errors

Common errors & fixes

Error: Cannot find module 'n8n-nodes-stream-csv-from-microsoft-sql'

Package not installed in n8n's node_modules or installed globally.

fix

Install via n8n UI: Settings > Community Nodes > Install, or run 'npm install n8n-nodes-stream-csv-from-microsoft-sql' inside n8n directory.

TypeError: (intermediate value).execute is not a function

Importing the default export instead of named export.

fix

Use import { MicrosoftSqlToCsv } from '...'

Upgrade

Version history

1.1.2latest on npm

Audit

Dependencies

n8n-workflowoptionalPeer dependency required to interact with n8n's workflow engine and node API.

Agent activity

4 hits · last 30 days

node

Resources

githubhttps://github.com/juniorUsca/n8n-nodes-download-csv-from-microsoft-sql ↗

packagen8n-nodes-stream-csv-from-microsoft-sql ↗

homepagehttps://github.com/juniorUsca/n8n-nodes-download-csv-from-microsoft-sql#readme ↗