ShareShelf — Community Resource Library

Engineered a community equipment-sharing platform leveraging Spring Boot, modern frontend, and custom Model Context Protocol (MCP) integrations for safe AI-assisted development and schema maintenance.

Building a community asset library with complex reservation schedules and trust ratings while ensuring AI coding tools never inadvertently modify production database schemas or execute unvetted migrations.

Engineered Java 21 / Spring Boot backend with PostgreSQL, paired with a custom read-only MCP server allowing Claude subagents to inspect real schema metadata and validate SQL queries safely.

Integrated a local PostgreSQL MCP server allowing AI coding tools read-only schema introspection and query validation, ensuring 100% schema safety during backend migration and development.

• ◆Configured `@modelcontextprotocol/server-postgres` MCP server with strict read-only access for safe query optimization.
• ◆Created specialized Claude Subagents (db-assistant, qa-bot) and skills for database analysis and TDD test execution.
• ◆Implemented full reservation, item availability, and user trust-rating systems.
• ◆Containerized database workflows and deployed production frontend to Vercel.