MCP does not work with certain valid MariaDB identifiers
Open
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 204
- Forks
- 85
- PR merge metrics
- No merged PRs in 30d
Description
Steps to reproduce:
- Create a table called
foo.bar - Ask agent to get the schema for the table
foo.bar - MCP will error saying the table identifier is invalid.
Unfortunately, if you ask the agent to quote the identifier, the MCP call will still error.
Error stems from the fact that the isidentifier Python string method is being utilized instead of using a different method to enforce MariaDB's identifier rules.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No file or test is named. Start by reproducing the schema request for the MariaDB table foo.bar, then locate the Python MCP code using isidentifier and compare it with MariaDB identifier rules. Done means valid identifiers such as foo.bar work, including when quoted.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mariadb, python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100