F
licenseNot graded
qualityD
maintenanceProvides authenticated access to PostgreSQL databases for Claude AI, enabling users to browse database tables, discover schemas, and execute custom SQL queries through natural language interaction.
-
Portfolio MCP Server
by HQVinh
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Portfolio MCP Servershow me your work experience"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Portfolio MCP Server
A small MCP server that gives Claude read access to data behind my portfolio site, backed by Postgres. Currently wired up to Claude only, but built to grow as more tools get added.
What it does
Exposes portfolio data as MCP tools so Claude can answer questions about it directly, instead of me pasting context in by hand.
Tools:
list_work_experience— returns all work experience entries (role, company, period, type, description, highlights), ordered by recency.
Related MCP server: PostgreSQL MCP Server
Setup
Requires Python 3.12+ and uv.
uv syncCreate a .env file in the project root:
DATABASE_URL_READ=postgresql://...
DATABASE_URL_WRITE=postgresql://...DATABASE_URL_READ is the only one currently used by the server. DATABASE_URL_WRITE is reserved for future write-capable tools.
Running
uv run server.pyThe server communicates over stdio, so it's meant to be launched by an MCP client (e.g. Claude Desktop or Claude Code) rather than run standalone. Point your client's MCP config at:
uv --directory <path-to-this-repo> run server.pyRoadmap
This is intentionally minimal right now — one read-only tool against one table. Planned expansion includes more tools covering other parts of the portfolio (projects, skills) and eventually write access via DATABASE_URL_WRITE.
This server cannot be deployed
Maintenance
ActivityStale
ResponsivenessNo issues
Related MCP Connectors
- dataOAuthco.thinair
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Query 40 databases from Claude, ChatGPT, or Cursor — on any device. Read-only, encrypted, audited.
Query your Postgres from ChatGPT or Claude without exposing the database or handing over credentials. Run npx boltschema connect next to your database and it dials out over HTTPS — no inbound firewall rule, no open port, works with localhost and VPC-private databases. Read-only is enforced by a SQL guard, a Postgres READ ONLY transaction, and a scoped role generated for you.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceExposes PostgreSQL database operations as tools for AI assistants, allowing SQL queries and schema inspection.-
- AlicenseAqualityDmaintenanceExposes PostgreSQL query execution, EXPLAIN, and schema inspection tools to MCP-compatible clients like Claude Desktop.31MIT
- FlicenseNot gradedqualityDmaintenanceConnects to a PostgreSQL database and exposes schema inspection and safe SELECT query execution as MCP tools and resources for use with Claude Desktop or any MCP-compatible client.-