Minimal chat client for CData Connect MCP Server using OpenAI.
- Install dependencies:
pip install -r requirements.txt- Configure environment:
cp .env.example .env
# Edit .env with your credentials:
# - OPENAI_API_KEY: Your OpenAI API key
# - MCP_USERNAME: CData Connect username
# - MCP_PASSWORD: CData Connect PAT token- Run:
python client.pyOnce connected, you can:
- List available databases: "show me all catalogs"
- Explore schemas: "what schemas are in SQL2?"
- View tables: "list tables in dbo schema"
- Run SQL queries: "select top 10 from customers"
- Type 'exit' to quit
client.py- Main chat interfacemcp_client/- MCP protocol implementation.env- Your configuration (create from .env.example)