Package Health Score

68 / 100

security
No known security issues
popularity
Limited
maintenance
Sustainable
community
Active

Explore Similar Packages

Security

No known security issues

All security vulnerabilities belong to production dependencies of direct and indirect packages.

Security and license risk for significant versions

Version			Vulnerabilities	License Risk
2.0.1	\|	09/2023	0 C 0 H 0 M 0 L	0 H 0 M 0 L
1.2.1	\|	05/2023	0 C 0 H 0 M 0 L	0 H 0 M 0 L
1.1.1	\|	06/2021	0 C 0 H 0 M 0 L	0 H 0 M 0 L
1.0.2	\|	03/2021	0 C 0 H 0 M 0 L	0 H 0 M 0 L

License

Apache-2.0

Security Policy

Is your project affected by vulnerabilities?

Scan your projects for vulnerabilities. Fix quickly with automated fixes. Get started with Snyk for free.

Get started free

Popularity

Limited

Weekly Downloads (118)

GitHub Stars: 13
Forks: 6
Contributors: 20

Direct Usage Popularity

The npm package fastify-mssql receives a total of 118 downloads a week. As such, we scored fastify-mssql popularity level to be Limited.

Based on project statistics from the GitHub repository for the npm package fastify-mssql, we found that it has been starred 13 times.

Downloads are calculated as moving averages for a period of the last 12 months, excluding weekends and known missing data points.

Community

Active

Readme.md: Yes
Contributing.md: Yes
Code of Conduct: Yes
Contributors: 20
Funding: No

With more than 10 contributors for the fastify-mssql repository, this is possibly a sign for a growing and inviting community.

Embed Package Health Score Badge

Maintenance

Sustainable

Commit Frequency

Open Issues: 1
Open PR: 2
Last Release: 1 year ago
Last Commit: 7 days ago

Further analysis of the maintenance status of fastify-mssql based on released npm versions cadence, the repository activity, and other data points determined that its maintenance is Sustainable.

An important project maintenance signal to consider for fastify-mssql is that it hasn't seen any new versions released to npm in the past 12 months, and could be considered as a discontinued project, or that which receives low attention from its maintainers.

As a healthy sign for on-going project maintenance, we found that the GitHub repository had at least 1 pull request or issue interacted with by the community.

Keep your project healthy

Check your package.json

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Node.js Compatibility: >=16

Age: 4 years
Dependencies: 1 Direct
Versions: 10
Install Size: 16.5 kB
Dist-tags: 1
# of Files: 19
Maintainers: 5
TS Typings: Yes

fastify-mssql has more than a single and default latest tag published for the npm package. This means, there may be other tags available for this package, such as next to indicate future releases, or stable to indicate stable releases.

Readme

fastify-mssql

MSSQL Plugin for Fastify.

Installation

npm install fastify-mssql

You will also need to have mssql dependency installed and @types/mssql when you are using TypeScript.

npm install mssql @types/mssql

Usage

Example

const Fastify = require('fastify')
const mssql = require('fastify-mssql')

const app = Fastify()

app.register(mssql, {
  server: 'my-host',
  port: 1433,
  user: 'my-user',
  password: 'my-password',
  database: 'my-database'
})

app.get('/users', async function (req, reply) {
  try {
    await app.mssql.pool.connect();
    const res = await app.mssql.pool.query('SELECT * FROM users');
    return { users: res.recordset }
  } catch (err) {
    return err;
  }
})

app.listen(3000)

If you need to access the SQL Data Types you can access them by using the mssql.sqlTypes property:

app.get('/users/:userId', async function (request) {
  try {
    const pool = await app.mssql.pool.connect()
    const query = 'SELECT * FROM users where id=@userID'
    const res = await pool
      .request()
      .input('userID', app.mssql.sqlTypes.Int, request.params.userId)
      .query(query)
    return { user: res.recordset }
  } catch (err) {
    return { error: err.message }
  }
})

fastify-mssql dependencies

fastify-plugin

fastify-mssql development dependencies

@types/jest @types/mssql eslint eslint-config-prettier eslint-plugin-import eslint-plugin-prettier fastify jest mssql prettier

FAQs

What is fastify-mssql?

Fastify Plugin to manage MSSQL connections. Visit Snyk Advisor to see a full health score report for fastify-mssql, including popularity, security, maintenance & community analysis.

Is fastify-mssql popular?

The npm package fastify-mssql receives a total of 118 weekly downloads. As such, fastify-mssql popularity was classified as limited. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is fastify-mssql well maintained?

We found indications that fastify-mssql maintenance is sustainable demonstrating some project activity. We saw a total of 20 open source contributors collaborating on the project. See the full package health analysis to learn more about the package maintenance status.

Is fastify-mssql safe to use?

The npm package fastify-mssql was scanned for known vulnerabilities and missing license, and no issues were found. Thus the package was deemed as safe to use. See the full health analysis review.

Last updated on 8 November-2024, at 09:51 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

fastify-mssql

Fastify Plugin to manage MSSQL connections For more information about how to use this package see README

Ensure you're using the healthiest npm packages

Package Health Score

Explore Similar Packages

Security

Security and license risk for significant versions

Is your project affected by vulnerabilities?

Popularity

Weekly Downloads (118)

Direct Usage Popularity

Community

Embed Package Health Score Badge

Maintenance

Commit Frequency

Keep your project healthy

Check your package.json

Snyk Vulnerability Scanner

Package

Readme

fastify-mssql

Installation

Usage

Example

fastify-mssql dependencies

fastify-mssql development dependencies

FAQs

What is fastify-mssql?

Is fastify-mssql popular?

Is fastify-mssql well maintained?

Is fastify-mssql safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Fix identified vulnerabilities

Monitor for new issues

Package Health Score

Explore Similar Packages

Security and license risk for significant versions

Is your project affected by vulnerabilities?

Weekly Downloads (118)

Direct Usage Popularity

Embed Package Health Score Badge

Commit Frequency

Keep your project healthy

Check your package.json

Snyk Vulnerability Scanner

Readme

fastify-mssql

Installation

Usage

Example

fastify-mssql dependencies

fastify-mssql development dependencies

FAQs

What is fastify-mssql?

Is fastify-mssql popular?

Is fastify-mssql well maintained?

Is fastify-mssql safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues