mcp-sql-api

mcp-sql-api/ ├── app/ │ ├── main.py # FastAPI entry point │ ├── api/ # Endpoint layer │ │ ├── sql.py # Raw SQL execution (step 1) │ │ ├── query.py # Query execution API (step 3) │ │ └── agent.py # GPT integration (step 2) │ │ │ ├── core/ # Core logic │ │ ├── db.py # DB connection (PostgreSQL) │ │ └── security.py # SQL control (SELECT restrictions, etc.) │ │ │ ├── services/ # Business logic │ │ ├── sql_executor.py # SQL execution engine │ │ ├── query_service.py # Template query execution │ │ ├── llm_service.py # SQL generation with GPT │ │ └── ir_service.py # Intermediate representation → SQL conversion (step 4) │ │ │ ├── models/ # Data models │ │ ├── schema.py # DB schema definition │ │ ├── query.py # Query definition (with semantics) │ │ └── ir.py # Intermediate representation (crucial) │ │ │ ├── repositories/ # DB access layer │ │ └── base.py │ │ │ └── utils/ │ ├── logger.py │ └── validator.py │ ├── metadata/ # ← Core of MCP │ ├── schema.yaml # Table definitions (for LLM) │ ├── metrics.yaml # KPI definitions │ └── queries.yaml # Semantic API definitions │ ├── prompts/ # Prompts for GPT │ ├── sql_generation.txt │ └── ir_generation.txt │ ├── tests/ │ ├── test_sql.py │ ├── test_query.py │ └── test_ir.py │ ├── requirements.txt └── README.md