50 lines
1.2 KiB
Bash
Executable File
50 lines
1.2 KiB
Bash
Executable File
#!/bin/bash
|
|
# Test MCP Server
|
|
|
|
echo "🧪 Testing MCP Server Configuration..."
|
|
echo ""
|
|
|
|
# Set environment variables
|
|
export MSSQL_SERVER="192.168.120.88"
|
|
export MSSQL_PORT="1433"
|
|
export MSSQL_USER="reptil1990"
|
|
export MSSQL_PASSWORD="!Delfine1!!!"
|
|
export MSSQL_DATABASE="Infra"
|
|
export MSSQL_ENCRYPT="true"
|
|
export MSSQL_TRUST_SERVER_CERTIFICATE="true"
|
|
|
|
echo "✅ Environment variables set"
|
|
echo ""
|
|
|
|
# Check syntax
|
|
echo "📝 Checking JavaScript syntax..."
|
|
node -c mssql-mcp-readonly.js
|
|
if [ $? -eq 0 ]; then
|
|
echo "✅ Syntax check passed"
|
|
else
|
|
echo "❌ Syntax errors found"
|
|
exit 1
|
|
fi
|
|
echo ""
|
|
|
|
echo "📦 Checking dependencies..."
|
|
npm list @modelcontextprotocol/sdk mssql 2>/dev/null | grep -E "@modelcontextprotocol|mssql"
|
|
echo ""
|
|
|
|
echo "✅ MCP Server is ready!"
|
|
echo ""
|
|
echo "📋 Available tools:"
|
|
echo " 1. execute_sql - Execute custom SELECT queries"
|
|
echo " 2. list_tables - List all database tables"
|
|
echo " 3. describe_table - Get table schema"
|
|
echo " 4. search_parts - Quick part search"
|
|
echo ""
|
|
echo "🔄 To use in Cursor:"
|
|
echo " 1. Restart Cursor completely"
|
|
echo " 2. MCP server will start automatically"
|
|
echo " 3. Ask AI to use the tools"
|
|
echo ""
|
|
echo "📖 Full documentation: MCP_TOOLS.md"
|
|
|
|
|