How do I use pvs-mcp-server?

1. Click on "Deploy Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@pvs-mcp-server query PVSales database for top 10 products by revenue" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

pvs-mcp-server

by pvsmark

Overview Schema Source Related Servers Discussions Admin

JavaScript

Local

SQL Anywhere MCP Server - PM2

Simple PM2 deployment for running one MCP server process per SQL Anywhere database.

Files

.env                         shared credentials and runtime settings
package.json                 npm scripts
ecosystem.config.cjs         generated PM2 process list
configs/*.json               generated DB connection config files
scripts/generate-configs.cjs config + PM2 generator
src/server.js                MCP server
src/start-connection.js      starts one DB config file
logs/.gitkeep                keeps logs folder in git

Related MCP server: MCP SQL Server

1. Install

npm install
npm install -g pm2

2. Set shared credentials

Edit .env once:

MCP_SERVER_API_KEY=change-this-user-key
ADMIN_API_KEYS=change-this-admin-key
ODBC_USER=readonly_user
ODBC_PASSWORD=readonly_password
CORS_ALLOWED_ORIGINS=https://your-openwebui-domain.com

Use a read-only SQL Anywhere account.

3. Generate DB config files and PM2 apps

Generate 5 databases on ports 8081 to 8085:

npm run generate:configs -- --count 5 --base-port 8081

This creates:

configs/db1.json
configs/db2.json
configs/db3.json
configs/db4.json
configs/db5.json
ecosystem.config.cjs

Default generated DSNs are:

DB1_DSN
DB2_DSN
DB3_DSN
DB4_DSN
DB5_DSN

To use your real DSN names in one command:

npm run generate:configs -- --names db1,db2,db3,db4,db5 --dsns TestData,PVSData,PVSales,ValueDB,SALT --base-port 8000

To generate a different number of databases:

npm run generate:configs -- --count 10 --base-port 8081

To use a custom DSN naming pattern:

npm run generate:configs -- --count 5 --dsn-prefix PVS_DB --dsn-suffix _DSN --base-port 8081

That generates DSNs like:

PVS_DB1_DSN
PVS_DB2_DSN
PVS_DB3_DSN
PVS_DB4_DSN
PVS_DB5_DSN

See all generator options:

npm run generate:configs -- --help

4. Check syntax

npm run check

5. Test one DB without PM2

npm run start:one -- configs/db1.json

Then open:

http://localhost:8081/health

Stop it with Ctrl+C after testing.

6. Start with PM2

npm run pm2:start
npm run pm2:save

7. Monitor

npm run pm2:status
npm run pm2:logs

Health checks:

http://localhost:8081/health
http://localhost:8082/health
http://localhost:8083/health
http://localhost:8084/health
http://localhost:8085/health

MCP endpoints:

http://localhost:8081/mcp
http://localhost:8082/mcp
http://localhost:8083/mcp
http://localhost:8084/mcp
http://localhost:8085/mcp

Use this auth header from Open WebUI or ChatGPT connector:

Authorization: Bearer <MCP_SERVER_API_KEY>

PM2 commands

npm run pm2:restart
npm run pm2:stop
npm run pm2:delete
npm run pm2:logs
npm run pm2:status

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityMaintained

ResponsivenessSyncing

Resources

GitHub Repository

Need Help?

Related Servers

Related MCP Connectors

CData Connect AIOAuth
com.cdata
Cloud-hosted MCP server for secure AI access to enterprise data sources via CData Connect AI.
Databases RAG Systems Cloud Platforms
2
Artificial Wit AIOAuth
com.artificialwit
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
ERP Systems CRM Knowledge & Memory
2
Draxlr AOAuth
com.draxlr.api
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Data Visualization Databases Search
151
dataOAuth
co.thinair
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Databases Developer Tools
2

Related MCP Servers

SQL Server MCP
Databases Developer Tools
cwilby
A
license
B
quality
D
maintenance
A Model Context Protocol server that enables AI assistants (Cursor, Windsurf, Claude Code) to interact with Microsoft SQL Server databases by providing connectivity through environment-configurable connections.
Updated 8 months ago (2026-01-14 06:28 UTC)
8
537 npm
8
MIT
MCP SQL Server
Databases Developer Tools
ryudg
A
license
Not graded
quality
D
maintenance
A Model Context Protocol server that provides AI assistants with comprehensive access to SQL databases, enabling schema inspection, query execution, and database operations with enterprise-grade security.
Updated a year ago (2025-05-26 13:46 UTC)
16 npm
7
MIT
NLSQL MCP Server
Databases Search Code Execution
tushar-badhwar
A
license
Not graded
quality
D
maintenance
An MCP (Model Context Protocol) server that exposes natural language to SQL functionality, allowing any MCP-compatible client to convert plain English questions into SQL queries for database interaction using AI.
Updated a year ago (2025-07-08 02:53 UTC)
3
MIT
SQL Server MCP
Databases Developer Tools
az-coder-123
A
license
B
quality
D
maintenance
An MCP server that connects AI assistants to Microsoft SQL Server databases, enabling schema exploration and read-only queries safely.
Updated 6 months ago (2026-03-29 15:10 UTC)
49
5 npm
4
MIT