Field notes / real systems
Practical guides for connecting AI tools to PostgreSQL, MySQL, and OpenAPI through hosted MCP links.
Build and verify PostgreSQL row-level security for AI agents with non-owner roles, FORCE RLS, explicit policies, controlled writes, and denial tests.
Set up shared Codex memory through MCP. Compare Codex Memories, AGENTS.md, task history, and hosted project memory for Codex, Cursor, and Claude Code.
Set up shared memory for the Cursor AI coding agent through MCP. Compare Cursor Memories, Rules, Memory Bank files, and hosted cross-client context.
Learn how Agent Memory MCP preserves structured project context across AI chats, supports handoffs, and differs from chat history or semantic memory.
Compare Claude Code memory, CLAUDE.md, auto memory, Claude's native memory, and a shared MCP memory server for persistent context across AI tools.
Learn what a Memory Bank MCP server does, how file-based memory differs from structured hosted Agent Memory, and which model fits your AI workflow.
Learn how multi-agent memory works, when agents should share context, how MCP supports handoffs, and which consistency and access-control problems matter.
Create a restricted PostgreSQL role for AI tools with table grants, default privileges, optional row security, timeouts, and denial tests.
Compare the benborla29 MySQL MCP server with Python, DBHub, and hosted alternatives by setup, credentials, permissions, and deployment model.
Connect Cursor to MySQL through a hosted MCP server. Create a restricted user, configure mcp.json, verify schema access, and test denied writes.
Compare 10 verified MCP servers using official docs, GitHub repositories, registry status, deployment model, write access, and maintenance signals.
Compare CrystalDBA Postgres MCP Pro, DBHub, pgEdge, Supabase, Neon, datamcp, and the deprecated official server by deployment, permissions, and use case.
Learn how to build an MCP server: define tools, choose local or remote transport, add auth and tests, then compare custom code with OpenAPI conversion.
Add a remote MCP server to ChatGPT through Developer mode. Covers apps, HTTPS endpoints, OAuth, permissions, testing, refreshes, and common errors.
Add MCP servers to Claude Code with the CLI or .mcp.json. Covers HTTP and stdio, local/project/user scopes, OAuth, API keys, testing, and fixes.
Connect Claude Code to PostgreSQL through a local or remote MCP server. Includes scopes, read-only roles, datamcp setup, testing, and fixes.
Connect Claude Desktop or Claude on the web to PostgreSQL through MCP, with a separate Claude Code path, permissions, OAuth, testing, and troubleshooting.
Connect Cursor to PostgreSQL through a hosted MCP link. Configure mcp.json, start read-only, verify schema tools, and test database access.
Connect ChatGPT to PostgreSQL without pasting a database URL into the chat. Set up a remote MCP app with OAuth, read-only access, and scoped permissions.
Connect Supabase to Cursor with the official MCP server or a database-focused PostgreSQL link. Compare both paths and configure scoped access.
Configure Cursor MCP with the exact mcp.json format. Compare project .cursor/mcp.json and global ~/.cursor/mcp.json, then verify local or remote servers.
Learn how database MCP servers expose schema and query tools to AI clients. Compare local, provider, self-hosted, and managed options safely.
Turn a FastAPI OpenAPI schema into a hosted MCP server. Connect /openapi.json, configure API auth, restrict methods, and test the MCP link.
Make a REST API read-only for AI agents with method filtering, endpoint visibility, least-privilege credentials, rate limits, approvals, and audit logs.
Learn how MCP authentication works with OAuth 2.1 and API keys, how authorization differs, and how to enforce scopes, permissions, and revocation.
Build an MCP governance program with server inventory, ownership, approval, least privilege, change control, monitoring, revocation, and incident response.
Build useful MCP logs without leaking secrets. Learn the event schema, correlation fields, denied-call tracking, retention, alerts, and incident workflow.
The npm PostgreSQL MCP package is deprecated and archived. Confirm its status, compare maintained alternatives, and preserve read-only behavior while migrating.
Turn a NestJS Swagger API into a hosted MCP server through OpenAPI, or choose native MCP for custom tools, resources, prompts, and workflows.
Compare OpenAPI-to-MCP conversion with a custom MCP server across tool design, authentication, workflows, hosting, maintenance, security, and cost.
Add MCP servers to VS Code through the gallery, Command Palette, or .vscode/mcp.json. Covers HTTP, stdio, OAuth, secure inputs, testing, and fixes.
Connect a Neon PostgreSQL branch to Claude and Cursor through a hosted MCP endpoint with a restricted role, verified TLS, and read-only access.
Compare hosted, self-hosted, and local MCP servers by security, credentials, cost, maintenance, team access, and operational ownership.
MCP security guide covering common risks, OAuth, token handling, least privilege, prompt injection, audit logs, revocation, and a production checklist.
Secure OpenAPI-to-MCP access by separating client authentication from upstream API credentials, with practical API key, Bearer, Basic, and OAuth guidance.
Turn an OpenAPI 3.x or Swagger documentation URL into a hosted remote MCP endpoint. Configure auth, read-only access, and test real API calls.
An MCP server exposes tools; an MCP gateway controls access to them. Compare architecture, authentication, permissions, credentials, audit, and use cases.
Set up datamcp in 60 seconds. 1 database or API and 1 MCP link, free forever.
Get Started Free