Personal Library MCP Server

Instructions

Implementation Reference

• server.py:116-127 (handler)

  The `search_books` tool handler implements a database search functionality using SQL 'LIKE' queries on both the book 'name' and 'isbn' columns. It is decorated with `@mcp.tool()` which handles the registration with the MCP framework.

  @mcp.tool()
  def search_books(query: str) -> str:
      """Searches for books by name or ISBN."""
      conn = get_db_connection()
      cursor = conn.cursor()
      cursor.execute("SELECT isbn, name FROM books WHERE name LIKE ? OR isbn LIKE ?", (f"%{query}%", f"%{query}%"))
      results = [dict(row) for row in cursor.fetchall()]
      conn.close()
      
      if results:
          return json.dumps(results, indent=2)
      return "No matches found."