Frequently Asked Questions (FAQ) about FastMCP Server

Q: What is FastMCP Server?

A: FastMCP Server is a server that provides SQL database interaction tools via a conversational AI interface. It uses the FastMCP framework to allow users to interact with databases using natural language.

Q: What are the key features of FastMCP Server?

A: Key features include executing SQL queries, listing available tables, describing table structures, executing non-query operations (INSERT, UPDATE, DELETE), listing ODBC drivers, and viewing database information.

Q: What are the requirements to install FastMCP Server?

A: The requirements include Python 3.7+, pyodbc, asyncio, the FastMCP framework, Microsoft SQL Server, and ODBC Driver 17 for SQL Server.

Q: How do I install FastMCP Server?

A: First, install the Python dependencies using pip install pyodbc asyncio fastmcp. Ensure you have Microsoft SQL Server installed and ODBC Driver 17 for SQL Server. Then, configure the connection settings in the script.

Q: How do I run the FastMCP Server?

A: Run the server using the command python mcp_sql_server.py. The server will initialize and establish a connection to the specified SQL Server database.

Q: What tools are available in FastMCP Server?

A: Available tools include query_sql, list_tables, describe_table, execute_nonquery, list_odbc_drivers, and database_info.

Q: What does the query_sql tool do?

A: The query_sql tool executes a SQL query and returns the results. If no query is provided, it defaults to SELECT * FROM [dbo].[Table_1].

Q: What does the list_tables tool do?

A: The list_tables tool lists all tables available in the database.

Q: What does the describe_table tool do?

A: The describe_table tool gets the structure of a specific table, including column information like names and data types.

Q: What does the execute_nonquery tool do?

A: The execute_nonquery tool executes INSERT, UPDATE, DELETE, or other non-query SQL statements.

Q: What does the list_odbc_drivers tool do?

A: The list_odbc_drivers tool lists all available ODBC drivers on the system.

Q: What does the database_info tool do?

A: The database_info tool gets general information about the connected database, such as server name, database name, SQL Server version, current server time, and table count.

Q: How does FastMCP Server handle errors?

A: The server handles various error conditions, such as database connection failures, SQL query syntax errors, table not found errors, and permission-related issues. All errors are logged, and appropriate error messages are returned to the client.

Q: Can I customize FastMCP Server?

A: Yes, you can add new database tools or modify existing ones by following the pattern used in the existing tools.

Q: What are some security considerations when using FastMCP Server?

A: Consider implementing input validation for SQL queries to prevent SQL injection and restrict database user permissions based on the principle of least privilege.

Q: What are some common troubleshooting issues with FastMCP Server?

A: Common issues include connection errors (verify SQL Server instance name), ODBC driver errors (confirm ODBC Driver 17 is installed), and permission errors (check Windows user permissions).

Q: How does FastMCP Server integrate with the UBOS platform?

A: FastMCP Server can be integrated into custom AI Agents built on the UBOS platform, allowing businesses to create specialized AI solutions tailored to their specific database management needs.