
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
- Does appwrite have any alternative solut...
Hi Everyone, ... I am looking for a solution for AWS ECS Fargate in appwrite. Can anyone let me know if this is possible?
- REQUEST FAILED IN MIGRATION
I was trying to moved my archived project to a self-host database . Though the Project is "read only" but there's a message that I can view and migrate data to...
- Request failedPlease check if your crede...
I was trying to moved my archived project to a self-host database . Appwrite said we can view and migrate data but my archived project is rendering "Please che...
