how to user queries with appwrite mcp without getting Appwrite Error: Invalid query: Syntax error?
database_list_documents function with such query:
TypeScript
{
"database_id": "database_id",
"collection_id": "collection_id",
"queries": [
"equal(\"user\",\"user_id\")",
"equal(\"achievement\",\"achievement_id\")",
"limit(1)"
]
}
returns error
TL;DR
Developers need to include the method and attribute parameters in their MCP queries for Appwrite. Utilize the correct syntax as outlined in the documentation provided at https://appwrite.io/docs/apis/rest#queries-string-format to avoid receiving the `Appwrite Error: Invalid query: Syntax error`.
In the `database_list_documents` function, ensure the query follows the correct format. For example:
```
{
"database_id": "database_id",
"collection_id": "collection_id",
"queries": [
"equal(\"user\",\"user_id\")",
"equal(\"achievement\",\"achievement_id\")",
"limit(You need to include the method and attribute parameters. Check: https://appwrite.io/docs/apis/rest#queries-string-format
Recommended threads
- mcp-server-appwrite 0.4 fails on startup...
I’m trying to use `mcp-server-appwrite` against Appwrite Cloud and the server authenticates successfully, but fails during startup validation when probing `tabl...
- open runtime version lacks behind
open runtime version in appwrite CLI is v4 while the hosted runtimes use v5, this mismatch does not permit to debug locally functions using recent runtimes (li...
- The /storage web page is not working in ...
The /storage web page is not working in Appwrite. Server : FRA