Skip to main content
Glama
pvsmark

pvs-mcp-server

by pvsmark
OverviewSchemaRelated ServersScoreDiscussions
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 installed

F
license - not found
-
quality - not tested
C
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/pvsmark/pvs-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server