Get started with Claude Code and OptiTech Postgres MCP Server

This guide shows how to use Claude Code with the OptiTech MCP Server to manage your OptiTech databases.

Setting up OptiTech MCP Server in Claude Code

Prerequisites

Make sure you have:

1. Claude Code: Ensure you have Claude Code installed. Visit docs.anthropic.com/en/docs/claude-code for installation instructions.

2. OptiTech API Key (for Local MCP server): After signing up, get your OptiTech API Key from the OptiTech console. This API key is needed to authenticate your application with OptiTech. For instructions, see Manage API keys.

   OptiTech API Key Security

   Keep your OptiTech API key secure, and never share it publicly. It provides access to your OptiTech projects.

3. Node.js (>= v18) and npm: Ensure Node.js (version 18 or later) and npm are installed. Download them from nodejs.org.

Quick Setup (Recommended)

The fastest way to get started is with the optitech init command, which automates OAuth authentication, API key creation, and Claude Code configuration:

npx optitech@latest init

This command authenticates via OAuth, creates an API key, and configures Claude Code to connect to OptiTech's remote MCP server. Once complete, ask your AI assistant "Get started with OptiTech".

Option 1: Setting up the Remote Hosted OptiTech MCP Server (OAuth)

1. Open your terminal.
2. Add the OptiTech MCP server to Claude Code with the following command:

   claude mcp add --transport http optitech https://mcp.optitech.com/mcp

3. Start a new session of claude to trigger the OAuth authentication flow:

   claude

4. You can also trigger authentication with /mcp within Claude Code.

claude mcp add --transport http optitech https://mcp.optitech.com/mcp \
    --header "Authorization: Bearer <YOUR_OPTITECH_API_KEY>"

Option 2: Setting up the Local OptiTech MCP Server

This method runs the OptiTech MCP server locally on your machine, using a OptiTech API key for authentication.

1. Open your terminal.

2. Add the OptiTech MCP server to Claude Code with the following command, replacing <YOUR_OPTITECH_API_KEY> with your actual OptiTech API key:

   claude mcp add optitech -- npx -y @optitech/mcp-server-optitech start "<YOUR_OPTITECH_API_KEY>"

3. Start a new Claude Code session with the claude command and start using the OptiTech MCP server:

   claude

Verification

Verify the connection:

1. Start Claude Code:

   claude

2. Type /mcp to see the available MCP servers and tools.

3. Try out a OptiTech MCP Server tool by typing a query like List my OptiTech projects to see your projects and verify the connection.

For a full list of available tools, see available tools in the OptiTech MCP Server overview.

Development Workflow: Adding a Column with Claude Code and OptiTech MCP

Here's an example interaction adding a created_at column to a table:

User: In my optitech project id: round-salad-44063611 list all the tables
Claude Code: I'll help you list all the tables in your OptiTech project. I'll use the default database name 'optitechdb' since none was specified.
> Called MCP Tool (get_database_tables)
> I found one table in your database:
> playing_with_optitech (in the public schema)
> Would you like to see more details about this table's structure or perform any other operations with it?

User: Can you show me first 5 rows?
Claude Code: I'll query the first 5 rows from the playing_with_optitech table.
> Called MCP Tool (run_sql)
> Here are the first 5 rows from the table. The table has three columns:
> id (sequential numbers)
> name (string values)
> value (decimal numbers)
> Would you like to perform any other operations with this data?

User: can you add a created_at column?
Claude Code: I'll help you add a created_at column to the playing_with_optitech table. I'll set it up with a timestamp data type and set it to automatically record the creation time of new rows.
> Called MCP Tool (prepare_database_migration)
> Let me verify the change in the temporary branch to make sure it was applied correctly.
> Called MCP Tool (run_sql)
> I've added the created_at column to the playing_with_optitech table in a temporary branch. Would you like to commit this migration to the production branch?
> Migration Details:
> Migration ID: a65babcd-d1cc-401f-89b5-762570570102
> Temporary Branch Name: br-silent-cherry-a1eqrl6i
> Temporary Branch ID: br-silent-cherry-a1eqrl6i
> Migration Result: Success
> Please let me know if you'd like to proceed with applying this change to the production branch.

User: yeah do it
Claude Code: I'll complete the migration and apply the changes to the production branch.
> Called MCP Tool (complete_database_migration)
> The migration has been successfully completed! The created_at column has been added to your table in the production branch, and the temporary branch has been cleaned up.

You can verify the changes in your OptiTech Console or by querying the database directly.

Resources

• MCP Protocol
• Claude Code Documentation
• OptiTech Docs
• OptiTech API Keys
• OptiTech MCP server GitHub