Library – MCP
- We will try to connect our mcp server which interacts with database with claude
Connecting to a mysql database
- Connection
- Cursor
-
For python to speak with mysql it needs a connector (external package)
-
External packages for mysql connection
-
Sample insert record
INSERT INTO `books` (`id`, `title`, `author`, `published_year`, `available_copies`, `total_copies`, `genre`, `available`, `active`, `tags`, `isbn`) VALUES ('B006', 'Python Crash Course', 'Eric Matthes', '2019', '5', '10', 'Programming', '1', '1', '[\"python\", \"beginner\", \"hands-on\"]', '9781593279288')
-
Refer Here for the changes done
-
Lets add this library mcp server to claude
-
Exercise: Since http requires subscripion, convert the transport to stdio and try with claude.
