open-index/open-npm huggingface dataset:
npm package: @hthuong09/postgres-mcp
Description: MCP server for interacting with PostgreSQL databases
Author: hthuong09
Latest version: 0.1.3

# MCP PostgreSQL Server

This is a Model Context Protocol server for interacting with PostgreSQL databases. It provides a read-only interface to query PostgreSQL databases and inspect their schema.

## Installation

```bash
npm install -g @hthuong09/postgres-mcp
```

## Configuration

The server can be configured in multiple ways, listed in order of priority:

1. **Environment Variables**
   - `POSTGRES_URL`: Full database URL (e.g., `postgres://user:pass@host:5432/dbname`)
   - Individual connection parameters:
     - `POSTGRES_HOST`: Database host
     - `POSTGRES_PORT`: Database port (default: 5432)
     - `POSTGRES_DB`: Database name
     - `POSTGRES_USER`: Database user
     - `POSTGRES_PASSWORD`: Database password
     - `POSTGRES_SSL`: Enable SSL mode (set to 'true' to enable)
     - `POSTGRES_SCHEMA`: Database schema (default: 'public')
   - Additional configuration:
     - `DOTENV_PATH`: Custom path to .env file
     - `DEBUG_MCP`: Enable debug logging (set to 'true' to enable)

2. **Command Line**
   ```bash
   npx @hthuong09/postgres-mcp "postgres://user:pass@host:5432/dbname"
   ```

### Resources

- Table schemas: Each table in the database is exposed as a resource
- Resource URI format: `postgres://user@host/dbname/table_name/schema`
- Response format: JSON array of column definitions (name and data type)

## Usage Examples

1. Using environment variables:
   ```bash
   export POSTGRES_HOST=localhost
   export POSTGRES_DB=mydb
   export POSTGRES_USER=myuser
   export POSTGRES_PASSWORD=mypassword
   npx @hthuong09/postgres-mcp
   ```

2. Using a connection URL:
   ```bash
   npx @hthuong09/postgres-mcp "postgres://myuser:mypassword@localhost:5432/mydb"
   ```

3. Using environment variables with SSL:
   ```bash
   export POSTGRES_HOST=db.example.com
   export POSTGRES_DB=mydb
   export POSTGRES_USER=myuser
   export POSTGRES_PASSWORD=mypassword
   export POSTGRES_SSL=true
   npx @hthuong09/postgres-mcp
   ```

4. Using a custom .env file location:
   ```bash
   DOTENV_PATH=/path/to/.env npx @hthuong09/postgres-mcp
   ```

## Security Considerations

- Database credentials should be kept secure
- Use environment variables or .env files instead of command line arguments in production to avoid exposing credentials in process lists
- Consider using SSL in production environments
- The server only allows read-only transactions for safety
- Passwords are automatically stripped from resource URIs

## Development

To build the server locally:

```bash
npm install
npm run build
```

To run in watch mode during development:

```bash
npm run watch
```

## Debugging

Set `DEBUG_MCP=true` to enable debug logging. Logs will be written to:
- Unix/macOS: `/tmp/postgres-mcp-debug.json`
- Windows: `%TEMP%/postgres-mcp-debug.json`

## License

MIT
npm package: @htibor/js-pipy
Description: Use pipeline to prettier code.
Author: Tibor Hegedűs
Latest version: 1.0.1

![js-pipy-social](https://banners.beyondco.de/%40htibor%2Fjs-pipy.png?theme=dark&packageManager=npm+install&packageName=%40htibor%2Fjs-pipy&pattern=autumn&style=style_2&description=Make+your+code+to+prettier+with+pipeline.&md=1&showWatermark=0&fontSize=100px&images=puzzle)

# js-pipy
Use pipeline to prettier code.

# Installation guide
- clone this repo locally
- `npm i @htibor/js-pipy --save`

# Usage
```js
const {pipy} = require('@htibor/js-pipy');

// example functions 
const capitalize = str => str.toUpperCase()
const exclaim = str => `${str}!!!`

pipy(capitalize, exclaim)('youareawesome');

// result: YOUAREAWESOME!!!
```
npm package: @htintegrations/flatpickr
Description: Hellotickets Datepicker based on flatpickr
Author: hellotickets
Latest version: 1.17.2

## Hellotickets flatpickr - javascript datetime picker (TS)

## Motivation
Based on flatpickr

Feature overview:

- Dependency-free (no bloated bundles)
- Simple, polished UX
- Date + time input
- Range selections
- Ability to select multiple dates
- Can be used as just a time picker
- Display dates in a human-friendly format
- Easily disable specific dates, date ranges, or any date using arbitrary logic
- Week numbers
- 51 locales
- 8 colorful themes (incl. dark and material)
- Numerous plugins
- Libraries available for React, Angular, Vue, Ember, and more

![](https://user-images.githubusercontent.com/11352152/36033089-f37dc1d0-0d7d-11e8-8ec4-c7a56d1ff92e.png)

flatpickr provides more functionality at a fraction of the size of other libraries.

## Compatibility
IE9 and up, Edge, iOS Safari 6+, Chrome 8+, Firefox 6+

## Install & Use

Demos and documentation: https://flatpickr.js.org

## Publish
```bash
git commit
git push origin master
npm login
# *.*.* is next version of package
npm version *.*.* 
npm publish
# copy hellotickets.css into ht-web project
cp github.com/hellotickets/vue-flatpickr-component/src/style/themes/hellotickets.css bitbucket.org/helloticketscode/ht-web/src/plugins/datepicker/themes/hellotickets.css
```

## Supporting flatpickr
Based on https://github.com/flatpickr/flatpickr
npm package: @htl-stp/core
Description: Core CSS for all of 'HLTSTP, but better!'
Author: daftvoid
Latest version: 1.1.1

# Core

Core CSS used in all "HTLSTP, but better!" projects. May be used outside of BB as well.

## Installation

Installation via npm:
```bash
npm install @htl-stp/core
```

Import (vite, ng, react):
```typescript
import "@htl-stp/core/core.css" // needed (bare minimum)
import "@htl-stp/core/utilities.css" // recommended (helpers)
import "@htl-stp/core/components.css" // optional, opinionated (buttons, cards)
```
npm package: @htl-weather-station/simple-live-widget
Description: Simple live widget to show the latest measurement of a specific station.
Author: htl-weather-station
Latest version: 1.2.3

# simple-live-widget

## Commands

```bash
# install dependencies
npm install

# serve with hot reload at localhost:3000
npm run dev

# build udm bundle to be embedded into other websites
npm run build

# lint the project with eslint to find code style issues
npm run lint
```

## Example Integration

This widget uses [preact-habitat](https://github.com/zouhir/preact-habitat) with the `inline` option.
Place a script with `bundle.js` into the container that should contain the widget.

```html
<!-- Container -->
<div>
  <script
    async
    src="https://unpkg.com/@htl-weather-station/simple-live-widget/dist/bundle.js"
  />
  <script type="text/props">
    {
      "url": "http://142.93.109.224",
      "stationId": "4"
    }
  </script>
</div>
```

You must pass two properties via a script tag of the type `text/props` or `text/json` into preact.
These include the URL on which the API is hosted and the ID of the station to be shown.

The widget should work for IE11+ and all other modern browsers.
Additional polyfills for IE8+ are provided in the same directory with `polyfills.js`.

CORS will prevent the widget from working if it is deployed to anything other than `localhost`.
In order for the widget to function your website will have to be added to the list of allowed origins.
npm package: @htlife/vue-window
Description: Vue component for window
Author: htlife
Latest version: 2.4.2

# vue-window
## Introduction
Recent web applications are mainly for mobile environments. Therefore window UI is no longer mainstream.
However, window UI is still useful for professional web applications for PC environments.
This package is an implementation of window UI for PC environment as a Vue Component.

### [Working Demo](https://michitaro.github.io/vue-window)
### Features
* Window component for vue2
* Windows are draggable
* Automatic z-index control
* Resizable
* z-index group
* Configurable color theme
* Built-in 3 color themes
* Open / Close animation
* Tested on Safari10, Chrome60, Firefox55, IE11, Edge38 For PCs 
* iOS Support 🎉

![Screenshot](./docs/screenshot.png)

# Usage
## Install
```sh
npm install --save @hscmap/vue-window
```

## Setup

### ES6 / TypeScript
```typescript
import Vue from 'vue'
import * as VueWindow from '@hscmap/vue-window'

Vue.use(VueWindow)
```

### CommonJS
```javascript
var Vue = require('vue')
Vue.use(require('@hscmap/vue-window'))
```

# Example
```html
<template>
    <hsc-window-style-metal>
        <hsc-window title="Window 1" >
            Parameters:
            <fieldset>
                <legend>&alpha;</legend>
                <input type="range" />
            </fieldset>
            <fieldset>
                <legend>&beta;</legend>
                <input type="range" />
            </fieldset>
        </hsc-window>
    </hsc-window-style-metal>
</template>
```

Other examples are available [here](http://michitaro.github.io/vue-window/).

see also [@hscmap/vue-menu](https://github.com/michitaro/vue-menu).
This is a menu UI component for vue2 with the same color themes.

# Contributing
Any comments, suggestions or PRs are welcome 😀