ai-agent-dev-week4-mcp-server

Overview

This MCP server exposes a Person database through a Streamable HTTP transport endpoint, authenticated by API keys. Each key is bound to a specific user, ensuring data isolation between different API key holders. The server provides standard CRUD operations on people records including listing, retrieving, creating, updating, and deleting entries. It uses Next.js 16 with App Router, TypeScript, Prisma 7, and Neon Postgres for data storage.

Try asking AI

After installing, here are 3 things you can ask your AI assistant:

• list_peoplelist_people(limit?)

  List of people, newest first.

  Try:Show me all people in the databaseTry:List the newest 5 peopleTry:Display all records in the people table
• get_personget_person(id)

  Retrieve a single person by their ID.

  Try:Get person with ID 123Try:Find the person record with ID 456Try:Show me details for person ID 789
• create_personcreate_person(name, email?, role?, notes?)

  Create a new person record.

  Try:Create a new person named John DoeTry:Add a person with email@example.com and role 'admin'Try:Create a new person record with name Jane Smith
• update_personupdate_person(id, ...fields)

  Update an existing person's fields.

  Try:Update person ID 123 with email newemail@example.comTry:Change the role of person ID 456 to 'manager'Try:Modify notes for person ID 789
• delete_persondelete_person(id)

  Delete a person record by ID.

  Try:Delete person with ID 123Try:Remove the person record with ID 456Try:Delete person ID 789 from the database

Comparable tools

Installation

npm run issue-key -- user@example.com "my laptop"

{
  "mcpServers": {
    "ai-agent-dev-week4": {
      "command": "npx",
      "args": ["ai-agent-dev-week4-mcp-server"],
      "env": {
        "DATABASE_URL": "your_database_url"
      }
    }
  }
}

Compare ai-agent-dev-week4-mcp-server with