open-index/open-npm huggingface dataset:
npm package: @liydu/mcp-server-mysql
Description: MCP server for interacting with MySQL databases based on Node
Author: Liya Du
Latest version: 1.0.9

# MCP Server for MySQL based on NodeJS
[![smithery badge](https://smithery.ai/badge/@benborla29/mcp-server-mysql)](https://smithery.ai/server/@benborla29/mcp-server-mysql)
![Demo](assets/demo.gif)

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

## Components

### Tools

- **mysql_query**
  - Execute read-only SQL queries against the connected database
  - Input: `sql` (string): The SQL query to execute
  - All queries are executed within a READ ONLY transaction

### Resources

The server provides schema information for each table in the database:

- **Table Schemas**
  - JSON schema information for each table
  - Includes column names and data types
  - Automatically discovered from database metadata

## Usage with Claude Desktop

To use this server with the Claude Desktop app, add the following configuration to the "mcpServers" section of your `claude_desktop_config.json`:

```json
{
  "mcpServers": {
    "mcp_server_mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@liydu/mcp-server-mysql",
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "",
        "MYSQL_DB": "db_name",
        "MYSQL_SSL": "true",
        "MYSQL_SSL_CA": "/etc/ssl/cert.pem",
        "MYSQL_SSL_REJECT_UNAUTHORIZED": "true"
      }

    }
  }
}
```

Replace `/db_name` with your database name or leave it blank to retrieve all databases.

## Troubleshooting
If you encounter an error "Could not connect to MCP server mcp-server-mysql", you may need to explicitly
set the path of all required binaries such as the configuration below:

```json
{
  "mcpServers": {
    "mcp_server_mysql": {
      "command": "/path/to/npx/binary/npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql",
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "",
        "MYSQL_DB": "db_name"
        "PATH": "/path/to/node/bin:/usr/bin:/bin" <-- Add this
      }

    }
  }
}
```

## License

This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
npm package: @liyi-it/l-panel
Description: A VUE folding panel
Author: Liyi
Latest version: 1.0.2

# ly-panel

> A Vue.js project

## Build Setup

``` bash
# install dependencies
npm install

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

# build for production with minification
npm run build
```

For detailed explanation on how things work, consult the [docs for vue-loader](http://vuejs.github.io/vue-loader).
npm package: @liyiping/abc
Description: Common business components of ng-alain.
Author: cipchk
Latest version: 1.4.0

# @delon/abc module [![Build Status](https://travis-ci.org/cipchk/delon.svg?branch=master)](https://travis-ci.org/cipchk/delon) [![NPM version](https://img.shields.io/npm/v/@delon/abc.svg)](https://www.npmjs.com/package/@delon/abc) [![NPM version](https://img.shields.io/npm/v/@delon/abc/next.svg)](https://www.npmjs.com/package/@delon/abc) [![Taobao version](https://npm.taobao.org/badge/v/@delon/abc.svg?style=flat-square)](https://npm.taobao.org/package/@delon/abc)

Common business components of ng-alain.

## Links

- [Api Document](http://ng-alain.com/components)
- [Demo](https://cipchk.github.io/ng-alain/)

## Architecture

![Architecture](https://raw.githubusercontent.com/cipchk/delon/master/_screenshot/architecture.png)

## Troubleshooting

Please follow this guidelines when reporting bugs and feature requests:

1. Use [GitHub Issues](https://github.com/cipchk/delon/issues) board to report bugs and feature requests (not our email address)
2. Please **always** write steps to reproduce the error. That way we can focus on fixing the bug, not scratching our heads trying to reproduce it.

Thanks for understanding!

### License

The MIT License (see the [LICENSE](https://github.com/cipchk/delon/blob/master/LICENSE) file for the full text)
npm package: @liyj1983/sharklet-cli
Description: @liyj1983/sharklet-cli
Author: leeyangjie@gmail.com
Latest version: 1.0.0

# sharklet-cli

The nodejs CLI tool of sharklet API.


## Installation

Install it and run your CLI commands.

```sh
$ npm install sharklet-cli -g
```

## Prerequisite

Node.js >= 10.x

### Notes

You must know your `AK`(`accessKeyId/accessKeySecret`), and the cloud product's `endpoint` and `apiVersion`.

## Usage

The CLI style tools:

### 1. Prepare an empty directory.
```sh
$ mkdir yourProject & cd yourProject
```

### 2. Initialize and coding with edge.js as example codes.
```sh
$ sharklet-cli init
```

```js
/**
 * Add the necessary event listener
 * @param {Event} fetch event, {Function} async function
 */
addEventListener('fetch', event => {
  event.respondWith(handleRequest(event.request));
})

/**
 * Make a response to client
 * @param {Request} request
 */
async function handleRequest(request) {
  return new Response('Hello World!', { status: 200 });
}
```

### 3. Config with your wangsu access, fill in the prompts here.
```sh
$ sharklet-cli config
```

### 4. Build code and you can test with gray env .
```sh
$ sharklet-cli build
```

### 5. Test your code now, you can also show your codes and related config.
```sh
$ curl -v 'http://yourdomain.com/yourpath/' -x 42.123.119.50:80
```

```sh
$ curl --resolve yourdomain.com:443:42.123.119.50 'https://yourdomain.com/yourpath/' -v
```

```sh
$ sharklet-cli build -s
```

### 6. Publish code only when you are ready online after detailed tests.
```sh
$ sharklet-cli publish
```

### 7. Test your code online and check your service ok.
```sh
$ curl -v 'https://yourdomain.com/yourpath/'
```

```sh
$ sharklet-cli publish -s
```


## License
The MIT License