MSSQL MCP Server
by JexinSam
- .github
- workflows
# .github/workflows/test.yml
name: Tests
on:
push:
branches: [ main ]
pull_request:
branches: [ main ]
jobs:
test:
runs-on: ubuntu-latest
services:
mssql:
image: mcr.microsoft.com/mssql/server:2019-latest
env:
ACCEPT_EULA: Y
MSSQL_PID: Express
MSSQL_SA_PASSWORD: testpassword
ports:
- 1433:1433
strategy:
matrix:
python-version: ["3.11", "3.12"]
steps:
- uses: actions/checkout@v4
- name: Set up Python ${{ matrix.python-version }}
uses: actions/setup-python@v4
with:
python-version: ${{ matrix.python-version }}
- name: Install dependencies
run: |
python -m pip install --upgrade pip
pip install -r requirements.txt
pip install -r requirements-dev.txt
pip install -e .
- name: Verify installation
run: |
# Show Python path
python -c "import sys; print('\n'.join(sys.path))"
# Try importing the module
python -c "import mssql_mcp_server; print('Module found at:', mssql_mcp_server.__file__)"
# List installed packages
pip list | grep mssql
# Show the content of site-packages
ls -R $(python -c "import site; print(site.getsitepackages()[0])")
- name: Run tests
env:
MSSQL_HOST: localhost
MSSQL_USER: sa
MSSQL_PASSWORD: testpassword
MSSQL_DATABASE: master
run: |
python -m pytest -v