Node TDS module for connecting to SQL Server databases.
Installations
npm install tediousScore
64.1
Supply Chain
91.1
Quality
88.1
Maintenance
100
Vulnerability
97.9
License
Developer
Developer Guide
Module System
CommonJS
Min. Node Version
>=18
Typescript Support
Yes
Node Version
18.20.4
NPM Version
10.7.0
Statistics
1,577 Stars
2,247 Commits
439 Forks
68 Watching
179 Branches
101 Contributors
Updated on 21 Nov 2024
Bundle Size
1.11 MB
Minified
359.83 kB
Minified + Gzipped
Languages
TypeScript (51.95%)
JavaScript (48.02%)
Dockerfile (0.03%)
Total Downloads
Cumulative downloads
Total Downloads
189,519,417
Last day
-19.7%
292,071
Compared to previous day
Last week
-3.8%
1,592,698
Compared to previous week
Last month
-0%
7,093,646
Compared to previous month
Last year
59.3%
71,033,346
Compared to previous year
Daily Downloads
Weekly Downloads
Monthly Downloads
Yearly Downloads
Dependencies
10
Dev Dependencies
28
Tedious (node implementation of TDS)
Tedious is a pure-Javascript implementation of the TDS protocol, which is used to interact with instances of Microsoft's SQL Server. It is intended to be a fairly slim implementation of the protocol, with not too much additional functionality.
NOTE: New columns are nullable by default as of version 1.11.0
Previous behavior can be restored using config.options.enableAnsiNullDefault = false. See pull request 230.
NOTE: Default login behavior has changed slightly as of version 1.2
See the changelog for version history.
Supported TDS versions
- TDS 7.4 (SQL Server 2012/2014/2016/2017/2019/2022)
- TDS 7.3.B (SQL Server 2008 R2)
- TDS 7.3.A (SQL Server 2008)
- TDS 7.2 (SQL Server 2005)
- TDS 7.1 (SQL Server 2000)
Installation
Node.js is a prerequisite for installing tedious. Once you have installed Node.js, installing tedious is simple:
npm install tedious
Getting Started
- Node.js + macOS
- Node.js + Red Hat Enterprise Linux
- Node.js + SUSE Linux Enterprise Server
- Node.js + Ubuntu
- Node.js + Windows
Documentation
More documentation and code samples are available at tediousjs.github.io/tedious/
Name
Tedious is simply derived from a fast, slightly garbled, pronunciation of the letters T, D and S.
Developer Survey
We'd like to learn more about how you use tedious:
Contributing
We welcome contributions from the community. Feel free to checkout the code and submit pull requests.
License
Copyright (c) 2010-2021 Mike D Pilsbury
The MIT License
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
No vulnerabilities found.
Reason
no dangerous workflow patterns detected
Reason
no binaries found in the repo
Reason
license file detected
Details
- Info: project has a license file: LICENSE:0
- Info: FSF or OSI recognized license: MIT License: LICENSE:0
Reason
SAST tool is run on all commits
Details
- Info: SAST configuration detected: CodeQL
- Info: all commits (30) are checked with a SAST tool
Reason
7 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 7
Reason
Found 10/26 approved changesets -- score normalized to 3
Reason
dependency not pinned by hash detected -- score normalized to 2
Details
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:42: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:47: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:72: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/codeql-analysis.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/lint-pull-request-title.yml:15: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/lint-pull-request-title.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:390: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:393: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:22: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:41: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:45: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:76: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:85: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:94: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:103: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:112: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:129: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:134: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:138: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:186: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:195: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:204: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:213: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:222: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:231: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:244: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:247: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:265: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:278: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:281: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:301: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:314: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:317: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:337: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:351: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nodejs.yml:354: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/nodejs.yml:373: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/nodejs.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:12: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/release.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:15: update your workflow using https://app.stepsecurity.io/secureworkflow/tediousjs/tedious/release.yml/master?enable=pin
- Warn: containerImage not pinned by hash: test/Dockerfile:1: pin your Docker image by updating mcr.microsoft.com/mssql/server:2022-latest to mcr.microsoft.com/mssql/server:2022-latest@sha256:45a1a9d13ca5574cf8e0fe4ae73ab77248b66d9c3132ac9658fb6c16dd72a8af
- Info: 0 out of 22 GitHub-owned GitHubAction dependencies pinned
- Info: 0 out of 18 third-party GitHubAction dependencies pinned
- Info: 0 out of 1 containerImage dependencies pinned
- Info: 7 out of 7 npmCommand dependencies pinned
Reason
detected GitHub workflow tokens with excessive permissions
Details
- Info: jobLevel 'actions' permission set to 'read': .github/workflows/codeql-analysis.yml:28
- Info: jobLevel 'contents' permission set to 'read': .github/workflows/codeql-analysis.yml:29
- Warn: jobLevel 'contents' permission set to 'write': .github/workflows/nodejs.yml:384
- Warn: no topLevel permission defined: .github/workflows/codeql-analysis.yml:1
- Warn: no topLevel permission defined: .github/workflows/lint-pull-request-title.yml:1
- Warn: no topLevel permission defined: .github/workflows/nodejs.yml:1
- Warn: no topLevel permission defined: .github/workflows/release.yml:1
Reason
no effort to earn an OpenSSF best practices badge detected
Reason
security policy file not detected
Details
- Warn: no security policy file detected
- Warn: no security file to analyze
- Warn: no security file to analyze
- Warn: no security file to analyze
Reason
project is not fuzzed
Details
- Warn: no fuzzer integrations found
Reason
11 existing vulnerabilities detected
Details
- Warn: Project is vulnerable to: GHSA-m5vv-6r4h-3vj9
- Warn: Project is vulnerable to: GHSA-67hx-6x53-jw92
- Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg
- Warn: Project is vulnerable to: GHSA-3xgq-45jj-v275
- Warn: Project is vulnerable to: GHSA-4q6p-r6v2-jvc5
- Warn: Project is vulnerable to: GHSA-78xj-cgh5-2h22
- Warn: Project is vulnerable to: GHSA-2p57-rm9w-gvfp
- Warn: Project is vulnerable to: GHSA-952p-6rrq-rcjv
- Warn: Project is vulnerable to: GHSA-9wv6-86v2-598j
- Warn: Project is vulnerable to: GHSA-c2qf-rxjj-qqgw
- Warn: Project is vulnerable to: GHSA-f5x3-32g6-xq36
Score
4.6
/10
Last Scanned on 2024-11-18
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.
Learn MoreOther packages similar to tedious
mssql
Microsoft SQL Server client for Node.js.
@opentelemetry/instrumentation-tedious
OpenTelemetry instrumentation for `tedious` database client for Microsoft SQL Server
@google-cloud/cloud-sql-connector
A JavaScript library for connecting securely to your Cloud SQL instances
@tediousjs/connection-string
SQL ConnectionString parser