[{"_1":2,"_307":-5,"_308":-5},"loaderData",{"_3":4,"_22":23,"_207":208},"root",{"_5":6,"_7":8},"toasts",[],"visitor",{"_9":10,"_11":12},"viewportWidth",1280,"visitorSession",{"_13":14,"_16":17,"_18":-5,"_19":20,"_21":-5},"attributes",[15],"bot","id",17868451,"membership","referenceId","0199c5aa-51b0-7759-8197-bc4efce79cc1","userAccount","routes/_public/mcp/servers/~namespace/~slug/_pages/_layout",{"_24":25,"_26":-5,"_27":28,"_29":40,"_123":124,"_205":206},"availableLocales",[],"githubUser","locale",{"_29":30,"_33":37,"_38":39},"mcpServer",{"_31":32,"_33":34,"_35":36},"description","A starter template for building MCP servers with SQLite database integration. Provides a foundation with SQL query tools, database seeding capabilities, and a development client for testing.","name","MCP Server Starter","readme","# API Endpoint MCP Server\n### Tools existed inside this MCP Server (As 10 September 2025):\n1. SQL tools for different databases (Postgres, MySQL, SQL, Oracle)\n2. \n\n\n## SQL tools for different databases (Postgres, MySQL, SQL, Oracle)\nAfter you deploying the MCP Server on the website, you will get a particular link called _**Base URL**_. With that link, you be able to access some information through the endpoints that is specified. If your Base URL such as `http://localhost:8787`, then you can use the endpoints as `http://localhost:8787/health`. You can test the endpoints using **_Postman_** as well.\n\nThis MCP Server do manage multiple databases of the same type and even from different types. Each of the DB type can be confirgured by putting ```','``` at the specific environment names for the one that have more than one database. For example:\n```python\n# SQL Environment Variables\nMSSQL_HOST=hans-server.database.windows.net, hans-server.database.windows.net, hans-server.database.windows.net\nMSSQL_PORT=1433, 1433, 1433\nMSSQL_USER=IdzhansKhairi, IdzhansKhairi, IdzhansKhairi\nMSSQL_PASSWORD=iloveEnfrasys@123, iloveEnfrasys@123, iloveEnfrasys@123\nMSSQL_DB=mssql-mcp, coffee_database, pastry_database\n```\n\nOther that that, the MCP Server also do supports multiple sessions at the same time. This means that two users be able to access the chatbot at the same time and access the MCP Server tools at the same time.\n\n**Notes:** The MCP Server currently does not have authentication yet to make sure which users be able to access certain database and certain data.\n\nBelow are the endpoints under the SQL Tools:\n| Method | Endpoint | Description |\n|--------|---------------- |-------------------------------------------- |\n| GET | /dbs | Lists all configured databases. |\n| GET | /health | Health check endpoint (server status). |\n| GET | /dbs | List all databases name from all database type |\n| GET | /dbs/aliases | List all databases aliases from all database type |\n| GET | /dbs/types | List all available databases types |\n| GET | /dbs/list-by-type | Health check endpoint (server status). |\n| POST | /sql/query | Executes an SQL query against a database. |\n\n\n\nTo specify what should be sent to the `/sql/query`, you have to send in JSON form with 2 information:\n1. `\"db\"` : To specify what kind of database that we wanted it to be connected to.\n - `\"pg\"` : PostgreSQL\n - `\"mysql\"` : MySQL\n - `\"mssql\"` : Microsoft SQL\n - `\"oracle\"`: Oracle\n2. `\"sql\"` : SQL Queries based on the database used.\n\nBelow is the exact format:\n```json\n{\n \"db\": \"mysql\", // Database Type\n \"sql\": \"SELECT * FROM orders LIMIT 10;\" // SQL queries based on db type\n}\n```\n### Database Used and Data\nIn this project, multiple relational database system were tested to ensure compatibility with the MCP Server. The database used are:\n- PostgreSQL\n- MySQL\n- Microsoft SQL Server (MSSQL)\n- Oracle Database\n\nEach database contains two custom tables with a few sample rows of data.\n- The tables are designed with different themes per database (e.g., hospital system, university system, employee system, etc.) so that outputs can be easily distinguished during testing.\n- This prevents confusion when retrieving results and makes it clear which database the data originated from.\n\n___\n#### **1) POSTGRESQL DATABASE (Library System)**\n\n**TABLE NAME:** `books`\n| book\\_id | title | author | genre | year\\_published |\n| -------- | ----------------------- | ----------- | --------- | --------------- |\n| 1 | The Silent Forest | John Rivers | Fiction | 2015 |\n| 2 | Data Science Simplified | Alice Tan | Education | 2020 |\n| 2 | Demon Slayer: Kimetsu no Yaiba | Koyoharu Gotouge | Fiction | 2016 |\n\n**TABLE NAME:** `members`\n| member\\_id | name | email | join\\_date | active |\n| ---------- | ---------- | ------------------------------------------------------- | ---------- | ------ |\n| 101 | Sarah Lim | [sarah@example.com](mailto:sarah@example.com) | 2021-03-10 | true |\n| 102 | Ahmad Zaki | [ahmad.zaki@example.com](mailto:ahmad.zaki@example.com) | 2022-07-22 | false |\n| 103 | Megan Raaj | [megan.raaj@example.com](mailto:megan.raaj@example.com) | 2025-09-10 | false |\n\nTesting Using Postman to retrieve information:\n```json\n// Get all table\n{\n \"db\": \"pg\",\n \"sql\": \"SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_type = 'BASE TABLE' ORDER BY table_name\"\n}\n\n// List all tables with columns + contents\n{\n \"db\": \"pg\",\n \"sql\": \"SELECT c.table_name, c.column_name, c.data_type FROM information_schema.columns c JOIN information_schema.tables t ON c.table_name = t.table_name WHERE t.table_schema = 'public' AND t.table_type = 'BASE TABLE' ORDER BY c.table_name, c.ordinal_position;\"\n}\n\n// List contents of a specific table with its columns - \"SELECT * FROM LIMIT 10;\"\n{\n \"db\": \"pg\",\n \"sql\": \"SELECT * FROM books LIMIT 10;\"\n}\n```\n\n___\n\n#### **2) MYSQL DATABASE (E-commerce Store)**\n\n**TABLE NAME:** `products`\n| product\\_id | name | category | price | stock |\n| ----------- | ------------- | ----------- | ------- | ----- |\n| 501 | Laptop X100 | Electronics | 3500.00 | 15 |\n| 502 | Running Shoes | Sports | 280.00 | 50 |\n| 503 | Office Table | Furniture | 200.00 | 10 |\n\n**TABLE NAME:** `orders`\n| order\\_id | product\\_id | customer\\_name | quantity | order\\_date |\n| --------- | ----------- | -------------- | -------- | ----------- |\n| 9001 | 501 | Daniel Wong | 1 | 2024-12-15 |\n| 9002 | 502 | Mei Li | 2 | 2025-01-20 |\n| 9003 | 503 | Syahid Akbar | 2 | 2025-09-10 |\n\nTesting Using Postman to retrieve information:\n```json\n// Get all table\n{\n \"db\": \"mysql\",\n \"sql\": \"SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_SCHEMA = DATABASE() AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME\"\n}\n\n// List all tables with columns + contents\n{\n \"db\": \"mysql\",\n \"sql\": \"SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME, ORDINAL_POSITION;\"\n}\n\n// List contents of a specific table with its columns - \"SELECT * FROM LIMIT 10;\"\n{\n \"db\": \"mysql\",\n \"sql\": \"SELECT * FROM orders LIMIT 10;\"\n}\n```\n\n___\n\n#### **3) MSSQL DATABASE (Hospital Management)**\n- There will be 3 database for mssql to simulate the ability to use 3 database in the same type at one time- These MSSQL Database is deployed in the Azure SQL Database and it has 3 database which is `mssql-mcp`, `coffee_database`and `pastry_database`.\n- Each of these databases will be having 2 tables with 3 rows for each tables.\n\n**DATABASE 1:** `mssql-mcp`\n---\n**TABLE NAME:** `patients`\n| patient\\_id | full\\_name | dob | blood\\_type | admitted |\n| ----------- | ------------ | ---------- | ----------- | ---------- |\n| P001 | Kevin Smith | 1990-05-21 | O+ | 2025-02-01 |\n| P002 | Aisha Rahman | 1985-11-03 | A- | 2025-02-07 |\n| P003 | Ariff Hafizal| 2001-08-06 | AB | 2025-09-01 |\n\n**TABLE NAME:** `doctors`\n| doctor\\_id | name | specialty | phone | available |\n| ---------- | ------------- | ---------- | ----------- | --------- |\n| D001 | Dr. Michael | Cardiology | 012-3456789 | Yes |\n| D002 | Dr. Nur Farah | Pediatrics | 019-8765432 | No |\n| D003 | Dr. Abd. Rahman| Surgeon | 011-78150955 | Yes |\n\n**DATABASE 2:** `coffee_database`\n---\n**TABLE NAME:** `CoffeeBeans`\n| bean\\_id | bean\\_name | origin | roast\\_level |\n| -------- | ---------- | -------- | ------------ |\n| 1 | Arabica | Brazil | Medium |\n| 2 | Robusta | Vietnam | Dark |\n| 3 | Liberica | Malaysia | Light |\n\n**TABLE NAME:** `CoffeeDrinks`\n| drink\\_id | drink\\_name | bean\\_id | milk\\_type | price |\n| --------- | ------------- | -------- | ---------- | ----- |\n| 1 | Latte | 1 | Whole | 4.5 |\n| 2 | Espresso | 2 | None | 3.0 |\n| 3 | Kopi Liberica | 3 | Condensed | 2.5 |\n\n**DATABASE 3:** `pastry_database`\n---\n**TABLE NAME:** `Pastries`\n| pastry\\_id | pastry\\_name | origin | main\\_flavor |\n| ---------- | ------------ | --------- | ------------ |\n| 1 | Croissant | France | Butter |\n| 2 | Egg Tart | Hong Kong | Custard |\n| 3 | Kuih Lapis | Malaysia | Coconut |\n\n**TABLE NAME:** `PastryOrders`\n| order\\_id | pastry\\_id | customer\\_name | quantity | price |\n| --------- | ---------- | -------------- | -------- | ----- |\n| 1 | 1 | Aisha | 2 | 7.0 |\n| 2 | 2 | John | 3 | 9.0 |\n| 3 | 3 | Mei Ling | 1 | 4.5 |\n\nTesting Using Postman to retrieve information:\n```json\n// Get all table\n{\n \"db\": \"mssql\",\n \"sql\": \"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME\"\n}\n\n// List all tables with columns + contents\n{\n \"db\": \"mssql\",\n \"sql\": \"SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME, ORDINAL_POSITION;\"\n}\n\n// List contents of a specific table with its columns - \"SELECT TOP 10 * FROM ;\"\n{\n \"db\": \"mssql\",\n \"sql\": \"SELECT TOP 10 * FROM Doctors;\"\n}\n```\n___\n\n#### **4) ORACLE DATABASE (University System)**\n\n**TABLE NAME:** `COURSES`\n\n| course\\_id | course\\_name | department | credits | semester |\n| ---------- | ------------------------- | ----------- | ------- | -------- |\n| CSE101 | Intro to Computer Science | Computing | 4 | Fall |\n| BUS201 | Marketing Basics | Business | 3 | Spring |\n| ENG301 | Thermodynamics | Engineering | 4 | Fall |\n\n**TABLE NAME:** `STUDENTS`\n| student\\_id | name | major | gpa | enrollment\\_year |\n| ----------- | --------- | ----------------------- | --- | ---------------- |\n| S1001 | Raj Kumar | Computer Science | 3.8 | 2021 |\n| S1002 | Emily Tan | Business Administration | 3.5 | 2020 |\n| S1003 | Ahmad Ali | Mechanical Engineering | 3.2 | 2019 |\n\nTesting Using Postman to retrieve information:\n```json\n// Get all table\n{\n \"db\": \"oracle\",\n \"sql\": \"SELECT DISTINCT table_name FROM user_tab_columns WHERE table_name NOT LIKE 'ROLLING$%' AND table_name NOT LIKE 'SCHEDULER_%' -- AND UPPER(table_name) NOT IN () ORDER BY table_name\"\n}\n\n// List all tables with columns + contents\n{\n \"db\": \"oracle\",\n \"sql\": \"SELECT table_name, column_name, data_type FROM user_tab_columns ORDER BY table_name, column_id\"\n}\n\n// List contents of a specific table with its columns\n{\n \"db\": \"oracle\",\n \"sql\": \"SELECT * FROM COURSES\"\n}\n```\n___\n\n\n### Database Environments\nThe MCP Server uses environment variables for database connections.\n - Not all environments are required. Only put the database that is required/existed.\n - If an environment for a database type is missing, the server will still run (It can be used for all database or just use for your desired database).\n - This project do supports SQLite but it will not be focused on since SQLite is usually for the local testing.\n - If more than one of the same database type appears, the put `,` in between for each of the variable. For example:\n ```.env\n MSSQL_USER=user1, user2\n MSSQL_PASSWORD=pass1, pass2\n MSSQL_DB=dbName1, dbName2\n ```\n\n\n\n| Variable | Usage / Description | Example Value |\n| ----------------------- | -------------------------------------------------------------- | ----------------------- |\n| `MYSQL_HOST` | Hostname or IP address of the MySQL server | `127.0.0.1` |\n| `MYSQL_PORT` | Port number for the MySQL server (default: `3306`) | `3306` |\n| `MYSQL_USER` | Username to authenticate with the MySQL server | `root` |\n| `MYSQL_PASSWORD` | Password for the MySQL user | `mypassword` |\n| `MYSQL_DB` | Name of the MySQL database to connect to | `test_db` |\n| `PG_HOST` | Hostname or IP address of the PostgreSQL server | `127.0.0.1` |\n| `PG_PORT` | Port number for the PostgreSQL server (default: `5432`) | `5432` |\n| `PG_USER` | Username to authenticate with the PostgreSQL server | `postgres` |\n| `PG_PASSWORD` | Password for the PostgreSQL user | `secret123` |\n| `PG_DB` | Name of the PostgreSQL database to connect to | `sampledb` |\n| `MSSQL_HOST` | Hostname or IP address of the Microsoft SQL Server | `127.0.0.1` |\n| `MSSQL_PORT` | Port number for the Microsoft SQL Server (default: `1433`) | `1433` |\n| `MSSQL_USER` | Username to authenticate with the Microsoft SQL Server | `sa` |\n| `MSSQL_PASSWORD` | Password for the Microsoft SQL Server user | `P@ssw0rd!` |\n| `MSSQL_DB` | Name of the Microsoft SQL Server database to connect to | `hospital_db` |\n| `ORACLE_CONNECT_STRING` | Oracle EZConnect string in the format `host:port/service_name` | `127.0.0.1:1521/XEPDB1` |\n| `ORACLE_USER` | Username to authenticate with the Oracle database | `system` |\n| `ORACLE_PASSWORD` | Password for the Oracle user | `oracle123` |\n\n\n### MCP Tools Available\nCopilot Studio (and any LLM-based orchestration) uses tool name + description + input schema to decide which tool to call. If descriptions are vague or repetitive, the model struggles to pick the right tool or understand when to use it. So far, these are the tools together with its description that we can refer. Any changes on the description can be done back in the `src/tools/sql/index.ts`.\n\nNote: `.sql.peek/schema/query` will be keep on adding depending on how many database for each type is added.\n| Tool Name | Description |\n| ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |\n| **db.aliases** | Return the list of available database aliases created/available on this server (e.g., mysql, mssql, mssql\\_2, pg, oracle). Call this first to discover which DBs you can query. |\n| **db.types** | List available database dialects (types), e.g., MySQL, PostgreSQL, MSSQL, Oracle. |\n| **db.names** | List database names (not aliases) across all configured databases (unique, sorted). |\n| **db.listByType** | List database names for a given dialect (type). unique=true (default) returns unique names; set unique=false for one row per alias; includeAliases=true to add alias. |\n| **mysql.sql.peek** | Return up to N rows from each base table in the chosen database. Dialect-aware and read-only. Use this to quickly inspect unknown schemas. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' (mysql pg mssql oracle sqlite) to disambiguate. |\n| **mysql.sql.schema** | Return a compact Markdown outline of tables and columns for the chosen database. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' to disambiguate. |\n| **mysql.sql.query** | Execute a parameterized SQL query against the chosen database. If you provide 'db' (database name, not alias), the target DB is resolved at runtime. Optionally provide 'type' to disambiguate databases with the same name. **Usage Tips:** 1. Use a single SELECT statement. 2. Always use \\:name placeholders (e.g., \\:from, \\:limit). 3. Avoid INSERT, UPDATE, DELETE unless explicitly allowed. 4. Use exact table/column names (call `sql.schema` first if unsure). 5. Add LIMIT/TOP/ROWNUM to keep results small. 6. Prefer ANSI SQL over vendor-specific syntax. |\n| **pg.sql.peek** | Return up to N rows from each base table in the chosen database. Dialect-aware and read-only. Use this to quickly inspect unknown schemas. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' (mysql pg mssql oracle sqlite) to disambiguate. |\n| **pg.sql.schema** | Return a compact Markdown outline of tables and columns for the chosen database. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' to disambiguate. |\n| **pg.sql.query** | Execute a parameterized SQL query against the chosen database. If you provide 'db' (database name, not alias), the target DB is resolved at runtime. Optionally provide 'type' to disambiguate databases with the same name. **Usage Tips:** 1. Use a single SELECT statement. 2. Always use \\:name placeholders (e.g., \\:from, \\:limit). 3. Avoid INSERT, UPDATE, DELETE unless explicitly allowed. 4. Use exact table/column names (call `sql.schema` first if unsure). 5. Add LIMIT/TOP/ROWNUM to keep results small. 6. Prefer ANSI SQL over vendor-specific syntax. |\n| **mssql.sql.peek** | Return up to N rows from each base table in the chosen database. Dialect-aware and read-only. Use this to quickly inspect unknown schemas. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' (mysql pg mssql oracle sqlite) to disambiguate. |\n| **mssql.sql.schema** | Return a compact Markdown outline of tables and columns for the chosen database. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' to disambiguate. |\n| **mssql.sql.query** | Execute a parameterized SQL query against the chosen database. If you provide 'db' (database name, not alias), the target DB is resolved at runtime. Optionally provide 'type' to disambiguate databases with the same name. **Usage Tips:** 1. Use a single SELECT statement. 2. Always use \\:name placeholders (e.g., \\:from, \\:limit). 3. Avoid INSERT, UPDATE, DELETE unless explicitly allowed. 4. Use exact table/column names (call `sql.schema` first if unsure). 5. Add LIMIT/TOP/ROWNUM to keep results small. 6. Prefer ANSI SQL over vendor-specific syntax. |\n| **mssql\\_2.sql.peek** | Return up to N rows from each base table in the chosen database. Dialect-aware and read-only. Use this to quickly inspect unknown schemas. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' (mysql pg mssql oracle sqlite) to disambiguate. |\n| **mssql\\_2.sql.schema** | Return a compact Markdown outline of tables and columns for the chosen database. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' to disambiguate. |\n| **mssql\\_2.sql.query** | Execute a parameterized SQL query against the chosen database. If you provide 'db' (database name, not alias), the target DB is resolved at runtime. Optionally provide 'type' to disambiguate databases with the same name. **Usage Tips:** 1. Use a single SELECT statement. 2. Always use \\:name placeholders (e.g., \\:from, \\:limit). 3. Avoid INSERT, UPDATE, DELETE unless explicitly allowed. 4. Use exact table/column names (call `sql.schema` first if unsure). 5. Add LIMIT/TOP/ROWNUM to keep results small. 6. Prefer ANSI SQL over vendor-specific syntax. |\n| **mssql\\_3.sql.peek** | Return up to N rows from each base table in the chosen database. Dialect-aware and read-only. Use this to quickly inspect unknown schemas. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' (mysql pg mssql oracle sqlite) to disambiguate. |\n| **mssql\\_3.sql.schema** | Return a compact Markdown outline of tables and columns for the chosen database. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' to disambiguate. |\n| **mssql\\_3.sql.query** | Execute a parameterized SQL query against the chosen database. If you provide 'db' (database name, not alias), the target DB is resolved at runtime. Optionally provide 'type' to disambiguate databases with the same name. **Usage Tips:** 1. Use a single SELECT statement. 2. Always use \\:name placeholders (e.g., \\:from, \\:limit). 3. Avoid INSERT, UPDATE, DELETE unless explicitly allowed. 4. Use exact table/column names (call `sql.schema` first if unsure). 5. Add LIMIT/TOP/ROWNUM to keep results small. 6. Prefer ANSI SQL over vendor-specific syntax. |\n| **oracle.sql.peek** | Return up to N rows from each base table in the chosen database. Dialect-aware and read-only. Use this to quickly inspect unknown schemas. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' (mysql pg mssql oracle sqlite) to disambiguate. |\n| **oracle.sql.schema** | Return a compact Markdown outline of tables and columns for the chosen database. If you provide 'db' (database name, not alias), this tool will resolve the right DB at runtime. Optionally provide 'type' to disambiguate. |\n| **oracle.sql.query** | Execute a parameterized SQL query against the chosen database. If you provide 'db' (database name, not alias), the target DB is resolved at runtime. Optionally provide 'type' to disambiguate databases with the same name. **Usage Tips:** 1. Use a single SELECT statement. 2. Always use \\:name placeholders (e.g., \\:from, \\:limit). 3. Avoid INSERT, UPDATE, DELETE unless explicitly allowed. 4. Use exact table/column names (call `sql.schema` first if unsure). 5. Add LIMIT/TOP/ROWNUM to keep results small. 6. Prefer ANSI SQL over vendor-specific syntax. |\n\n\n\n### Deployment to Azure Web App\nDelete the existing node_modules and installs dependencies exactly as listed in your `package-lock.json` _**(ci = clean install)**_:\n```cmd\nnpm ci\n```\n\nRuns the build script in your package.json under \"scripts\":\n```cmd\nnpm run build\n```\n\nRemove of the directory if exist:\n```cmd\nif exist srcpkg rmdir /s /q srcpkg\n```\n\nMake directory to be zipped:\n```cmd\nmkdir srcpkg\n```\n\nCopy project sources and assets Oryx needs. If you read any templates at runtime, include them too. **DO NOT** copy `node_modules` _**(Oryx will install on Linux)**_:\n```cmd\nxcopy src srcpkg\\src\\ /E /I /Y\ncopy package.json srcpkg\\\ncopy package-lock.json srcpkg\\ >NUL 2>&1\ncopy tsconfig.json srcpkg\\ >NUL 2>&1\ncopy dbs.yaml srcpkg\\ >NUL 2>&1\ncopy policies.yaml srcpkg\\ >NUL 2>&1\nif exist src\\tools\\sql\\templates xcopy src\\tools\\sql\\templates srcpkg\\src\\tools\\sql\\templates\\ /E /I /Y\n```\n\nBuild a ZIP whose root is the content _**(not a nested folder)**_:\n```cmd\nif exist artifact-src.zip del /f /q artifact-src.zip\ntar -a -c -f artifact-src.zip -C srcpkg .\n```\n\nAzure Login:\n```cmd\naz login\n```\n\nSet runtime to Node 20 LTS:\n```cmd\naz webapp config set -g -n --linux-fx-version \"NODE|20-lts\"\n```\n\nEnable build automation _**(Oryx)**_:\n```cmd\naz webapp config appsettings set -g -n --settings SCM_DO_BUILD_DURING_DEPLOYMENT=true NPM_CONFIG_PRODUCTION=false\n```\n\nDeploy to Azure:\n```cmd\naz webapp deploy -g -n --src-path artifact-src.zip\n```\n\nEnable Logs and Monitor to view _**(In another cmd)**_:\n```cmd\naz webapp log config -g -n --application-logging filesystem --docker-container-logging filesystem --level information\n\naz webapp log tail -g -n \n```\n\nFind the outbound IP - to put in the SQL Server if your server is inside Azure\n```cmd\naz webapp show -g -n --query outboundIpAddresses -o tsv\n```\n\n\n### Using REST API Endpoints in Azure AI Foundry Agents\nIf you want to use API Endpoints instead of MCP endpoints in your Azure AI Foundry, you can register them as a Custom Tool using the OpenAPI 3.0 Specified Tool.\n\nHere’s a sample .json schema you can use. Just change the url with the right **Azure Web App URL**:\n```json\n{\n \"openapi\": \"3.0.1\",\n \"info\": {\n \"title\": \"MCP SQL Server API\",\n \"version\": \"1.0.0\",\n \"description\": \"REST API wrapper for MCP SQL server endpoints.\"\n },\n \"servers\": [\n {\n \"url\": \"https://\"\n }\n ],\n \"paths\": {\n \"/dbs\": {\n \"get\": {\n \"summary\": \"List all databases\",\n \"operationId\": \"listDatabases\",\n \"responses\": {\n \"200\": {\n \"description\": \"Successful response\",\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"string\"\n }\n }\n }\n }\n }\n }\n }\n },\n \"/dbs/aliases\": {\n \"get\": {\n \"summary\": \"List all database aliases\",\n \"operationId\": \"listDatabaseAliases\",\n \"responses\": {\n \"200\": {\n \"description\": \"Successful response\",\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"string\"\n }\n }\n }\n }\n }\n }\n }\n },\n \"/dbs/types\": {\n \"get\": {\n \"summary\": \"List all SQL database types/engines/dialect\",\n \"operationId\": \"listDatabaseTypes\",\n \"responses\": {\n \"200\": {\n \"description\": \"Successful response\",\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"string\"\n }\n }\n }\n }\n }\n }\n }\n },\n \"/dbs/list-by-type\": {\n \"get\": {\n \"summary\": \"List all SQL database names available by types/engines/dialect\",\n \"operationId\": \"listDatabaseByTypes\",\n \"responses\": {\n \"200\": {\n \"description\": \"Successful response\",\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"string\"\n }\n }\n }\n }\n }\n }\n }\n },\n \"/sql/query\": {\n \"post\": {\n \"summary\": \"Execute SQL query against a database\",\n \"operationId\": \"executeSqlQuery\",\n \"requestBody\": {\n \"required\": true,\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"object\",\n \"properties\": {\n \"db\": {\n \"type\": \"string\",\n \"description\": \"The database name to run the query on based on user input\"\n },\n \"type\": {\n \"type\": \"string\",\n \"enum\": [\n \"mysql\",\n \"mssql\",\n \"oracle\",\n \"pg\"\n ],\n \"description\": \"The type of database engine/dialect\"\n },\n \"sql\": {\n \"type\": \"string\",\n \"description\": \"The SQL query to execute based on the database type\"\n }\n },\n \"required\": [\n \"db\",\n \"type\",\n \"sql\"\n ]\n },\n \"example\": {\n \"db\": \"pastry_database\",\n \"type\": \"mssql\",\n \"sql\": \"SELECT TOP 10 * FROM PastryOrders;\"\n }\n }\n }\n },\n \"responses\": {\n \"200\": {\n \"description\": \"Query executed successfully\",\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"object\",\n \"properties\": {\n \"rows\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"object\"\n }\n },\n \"message\": {\n \"type\": \"string\"\n }\n }\n }\n }\n }\n }\n }\n }\n }\n }\n}\n```\n","English","tag","en-US",{"_41":42,"_13":43,"_49":32,"_50":32,"_16":51,"_52":53,"_33":34,"_65":66,"_73":-5,"_74":-5,"_75":76,"_112":113,"_117":-5,"_60":100,"_118":119,"_63":120,"_121":122},"addedAt","2025-08-29T09:00:32.187041Z",[44,45,46,47,48],"category:databases","category:developer-tools","environment:local","language:typescript","license_grade:f","descriptionMarkdown","descriptionPlainText",10942,"integrations",[54],{"_55":56,"_31":62,"_63":64},"brand",{"_57":58,"_33":59,"_60":61},"logoSvgPath","M21.678.521c-1.032-.92-2.28-.55-3.513.544a8.71 8.71 0 0 0-.547.535c-2.109 2.237-4.066 6.38-4.674 9.544.237.48.422 1.093.544 1.561a13.044 13.044 0 0 1 .164.703s-.019-.071-.096-.296l-.05-.146a1.689 1.689 0 0 0-.033-.08c-.138-.32-.518-.995-.686-1.289-.143.423-.27.818-.376 1.176.484.884.778 2.4.778 2.4s-.025-.099-.147-.442c-.107-.303-.644-1.244-.772-1.464-.217.804-.304 1.346-.226 1.478.152.256.296.698.422 1.186.286 1.1.485 2.44.485 2.44l.017.224a22.41 22.41 0 0 0 .056 2.748c.095 1.146.273 2.13.5 2.657l.155-.084c-.334-1.038-.47-2.399-.41-3.967.09-2.398.642-5.29 1.661-8.304 1.723-4.55 4.113-8.201 6.3-9.945-1.993 1.8-4.692 7.63-5.5 9.788-.904 2.416-1.545 4.684-1.931 6.857.666-2.037 2.821-2.912 2.821-2.912s1.057-1.304 2.292-3.166c-.74.169-1.955.458-2.362.629-.6.251-.762.337-.762.337s1.945-1.184 3.613-1.72C21.695 7.9 24.195 2.767 21.678.521m-18.573.543A1.842 1.842 0 0 0 1.27 2.9v16.608a1.84 1.84 0 0 0 1.835 1.834h9.418a22.953 22.953 0 0 1-.052-2.707c-.006-.062-.011-.141-.016-.2a27.01 27.01 0 0 0-.473-2.378c-.121-.47-.275-.898-.369-1.057-.116-.197-.098-.31-.097-.432 0-.12.015-.245.037-.386a9.98 9.98 0 0 1 .234-1.045l.217-.028c-.017-.035-.014-.065-.031-.097l-.041-.381a32.8 32.8 0 0 1 .382-1.194l.2-.019c-.008-.016-.01-.038-.018-.053l-.043-.316c.63-3.28 2.587-7.443 4.8-9.791.066-.069.133-.128.198-.194Z","SQLite","slug","sqlite","Provides tools for executing named SQL queries against a SQLite database using allow-listed templates for safe database operations.","uid","vxnfqvxb9c","namespace",{"_67":68,"_60":72},"owner",{"_69":70},"githubAccount",{"_71":72},"login","Muhammad-Idzhans","readmeMarkdown","redditPostExternalId","repository",{"_77":78,"_85":86,"_89":90,"_107":-5,"_108":109,"_110":-5,"_111":-5},"argumentsJsonSchema",{"_79":80,"_81":82,"_83":84},"properties",{},"required",[],"type","object","githubProject",{"_35":36,"_87":88},"url","https://github.com/Muhammad-Idzhans/mcp-server","githubRepository",{"_91":92,"_93":94,"_95":96,"_16":97,"_98":99,"_33":100,"_67":101,"_103":104,"_105":-5,"_106":104},"defaultBranch","master","fullName","Muhammad-Idzhans/mcp-server","githubTreeId",1033468,24847,"language","TypeScript","mcp-server",{"_71":72,"_63":102},"jpvlhyfr7x","recentStargazers",0,"spdxLicense","stargazers","glamaJson","inspectable",true,"npmPackage","supportedPlatforms","scores",{"_114":104,"_115":-5,"_116":-5},"license","quality","security","simpleIcon","toolCount",1,"131qwc7gzw","updatedAt","2025-10-06T14:50:56.343940Z","meta",[125,128,130,137,140,142,145,148,151,154,157,159,162,165,167,169,171,173,175],{"_126":127},"title","MCP Server Starter | Glama",{"_129":32,"_33":31},"content",{"_131":132,"_133":134,"_135":136},"href","https://glama.ai/mcp/servers/@Muhammad-Idzhans/mcp-server","rel","canonical","tagName","link",{"_129":34,"_138":139},"property","og:title",{"_129":32,"_138":141},"og:description",{"_129":143,"_138":144},"https://glama.ai/logo.png","og:logo",{"_129":146,"_138":147},"https://glama.ai/mcp/servers/@Muhammad-Idzhans/mcp-server/og-image","og:image",{"_129":149,"_138":150},"630","og:image:height",{"_129":152,"_138":153},"1200","og:image:width",{"_129":155,"_138":156},"website","og:type",{"_129":132,"_138":158},"og:url",{"_129":160,"_138":161},"Glama – MCP Hosting Platform","og:site_name",{"_129":163,"_33":164},"summary_large_image","twitter:card",{"_129":160,"_33":166},"twitter:title",{"_129":32,"_33":168},"twitter:description",{"_129":146,"_33":170},"twitter:image",{"_129":149,"_33":172},"twitter:image:height",{"_129":152,"_33":174},"twitter:image:width",{"_176":177},"script:ld+json",{"_178":179,"_180":181},"@context","http://schema.org","@graph",[182],{"_178":183,"_184":185,"_186":187},"https://schema.org","@type","BreadcrumbList","itemListElement",[188,194,198,202],{"_184":189,"_190":191,"_33":192,"_193":119},"ListItem","item","/","Glama","position",{"_184":189,"_190":195,"_33":196,"_193":197},"/mcp","MCP",2,{"_184":189,"_190":199,"_33":200,"_193":201},"/mcp/servers","Servers",3,{"_184":189,"_190":203,"_33":34,"_193":204},"/mcp/servers/@Muhammad-Idzhans/mcp-server",4,"visitorIsMaintainer",false,"routes/_public/mcp/servers/~namespace/~slug/_pages/_explorer/blob/~commit/~/_route",{"_209":210,"_29":216,"_232":233,"_123":244,"_242":268,"_269":270},"blob",{"_129":211,"_212":213,"_214":215},"# Node\nnode_modules\nnpm-debug.log*\nyarn-debug.log*\nyarn-error.log*\npnpm-debug.log*\ndist\n\n# Env\n.env\n\n# Other files\nmcp-server.zip\nnvm-setup.exe\nartifact.zip\nartifact-src.zip\n\n# Other folders\nsrcpkg\nrelease\n","fileName",".gitignore","size",206,{"_41":42,"_13":217,"_49":32,"_50":32,"_16":51,"_52":218,"_33":34,"_65":221,"_73":-5,"_74":-5,"_75":224,"_112":231,"_117":-5,"_60":100,"_118":119,"_63":120,"_121":122},[44,45,46,47,48],[219],{"_55":220,"_31":62,"_63":64},{"_57":58,"_33":59,"_60":61},{"_67":222,"_60":72},{"_69":223},{"_71":72},{"_77":225,"_85":228,"_89":229,"_107":-5,"_108":109,"_110":-5,"_111":-5},{"_79":226,"_81":227,"_83":84},{},[],{"_35":36,"_87":88},{"_91":92,"_93":94,"_95":96,"_16":97,"_98":99,"_33":100,"_67":230,"_103":104,"_105":-5,"_106":104},{"_71":72,"_63":102},{"_114":104,"_115":-5,"_116":-5},"member",{"_234":235,"_238":239,"_240":213,"_95":96,"_241":206,"_242":213,"_243":109,"_214":215,"_83":209},"commit",{"_236":237},"sha","4da1cdaecc502d772c542a7f87bf61aed3925985","contentStoredObjectPointerId",10975043,"fullPath","indexable","path","safeToDisplayAsText",[245,247,249,251,253,254,255,257,258,259,260,261,262,263,264,265,266,267],{"_126":246},".gitignore | MCP Server Starter | Glama",{"_129":248,"_33":31},"Enterprise-grade security, privacy, and features like agents, MCP, prompt templates, and more.",{"_131":250,"_133":134,"_135":136},"https://glama.ai/mcp/servers/@Muhammad-Idzhans/mcp-server/blob/4da1cdaecc502d772c542a7f87bf61aed3925985/",{"_129":252,"_138":139},".gitignore | MCP Server Starter",{"_129":248,"_138":141},{"_129":143,"_138":144},{"_129":256,"_138":147},"https://glama.ai/generated-images/og?title=.gitignore+%7C+MCP+Server+Starter",{"_129":149,"_138":150},{"_129":152,"_138":153},{"_129":155,"_138":156},{"_129":250,"_138":158},{"_129":160,"_138":161},{"_129":163,"_33":164},{"_129":160,"_33":166},{"_129":248,"_33":168},{"_129":256,"_33":170},{"_129":149,"_33":172},{"_129":152,"_33":174},"","treeMembers",[271,275,278,281,284,286,289,292,295,298,301,304],{"_234":272,"_240":273,"_242":273,"_83":274},{"_236":237},"dev","tree",{"_234":276,"_240":277,"_242":277,"_83":274},{"_236":237},".github",{"_234":279,"_240":280,"_242":280,"_83":274},{"_236":237},"src",{"_234":282,"_240":283,"_242":283,"_83":209},{"_236":237},"dbs.yaml",{"_234":285,"_240":213,"_242":213,"_83":209},{"_236":237},{"_234":287,"_240":288,"_242":288,"_83":209},{"_236":237},"package.json",{"_234":290,"_240":291,"_242":291,"_83":209},{"_236":237},"package-lock.json",{"_234":293,"_240":294,"_242":294,"_83":209},{"_236":237},"policies.yaml",{"_234":296,"_240":297,"_242":297,"_83":209},{"_236":237},"README.md",{"_234":299,"_240":300,"_242":300,"_83":209},{"_236":237},"sql_audit.log",{"_234":302,"_240":303,"_242":303,"_83":209},{"_236":237},"tsconfig.json",{"_234":305,"_240":306,"_242":306,"_83":209},{"_236":237},".txt","actionData","errors"]

MCP directory API