I have a problem with adding the MCP server to the Cursor.
I have created an API, added a MCP server to Cursor, it shows the tools, so it should be properly installed.
But still the agent is not able to list tables or run SQL, it returns a 404.
Even if I provide the correct database nema, branch and project id, I get a 404.
AGENT trace:
“”“”
I’ll try again to list the tables in your “****” database:
Called MCP toolget_database_tables
Let me try a different approach using SQL with the branch ID we know exists:
Calling MCP toolrun_sql
{
“params”: {
“projectId”: “***”,
“databaseName”: “***”,
“branchId”: “***”,
“sql”: “SELECT table_schema, table_name FROM information_schema.tables WHERE table_schema NOT IN (‘pg_catalog’, ‘information_schema’, ‘neon_system’) ORDER BY table_schema, table_name;”
}
}
try again
I’ll try again to list the tables in your database:
Called MCP toolrun_sql
Parameters:
{
“params”: {
“projectId”: “***”,
“databaseName”: “***”,
“sql”: “SELECT table_schema, table_name FROM information_schema.tables WHERE table_schema NOT IN (‘pg_catalog’, ‘information_schema’, ‘neon_system’) ORDER BY table_schema, table_name;”
}
}
Result:
Request failed with status code 404
We’re still getting the same 404 error…
“”“”
I have tried regenerating a key and a direct curl call to the API (which works for both keys) but have had no luck! I’m out of ideas on how to make the MCP work in Cursor. Do you have any ideas?
If i understand your reply correctly, you are saying that even with inspector calling get_database_tables returns 404? if yes then only neon tech can help if they are the maker of that mcp or API.