GibsonAI MCP Server

What is GibsonAI MCP Server about?

GibsonAI MCP Server enables IDE‑based clients such as Cursor, Windsurf, Claude Desktop, and VS Code extensions to manage GibsonAI projects, design schemas, run queries, and deploy applications without leaving the development environment.

How to use GibsonAI MCP Server?

Authenticate with the Gibson CLI:

uvx --from gibson-cli@latest gibson auth login

Configure the MCP server in the client you prefer (Cursor, Windsurf, Claude Desktop, VS Code, Cline) by adding a gibson entry that runs:
```
{
  "command": "uvx",
  "args": ["--from", "gibson-cli@latest", "gibson", "mcp", "run"]
}
```
Interact using natural‑language prompts, e.g., “Create a blogging platform schema with users, posts, and comments.” The server processes the request, updates the model, and returns results directly in the IDE.

Key features of GibsonAI MCP Server

Project management – list, create, rename, and fetch metadata of GibsonAI projects.
Schema tooling – generate, modify, and retrieve working or deployed database schemas; automatic migrations and PR creation.
Database operations – obtain hosted connection details, run arbitrary SQL queries, seed tables with mock data.
Deployment – trigger schema migrations and deploy to development or production environments.
Multi‑client support – works with Cursor, Windsurf, Claude Desktop, VS Code Copilot, and the Cline extension.
Authentication reuse – leverages the Gibson CLI login, ensuring secure API access.

Use cases of GibsonAI MCP Server

Rapid prototyping – designers can sketch an ER diagram, convert it to a relational schema, and explore it instantly in the IDE.
Full‑stack development – developers generate backend schemas, seed data, and deploy to production with a single natural‑language command.
Database migration automation – schema changes are turned into GitHub PRs automatically, streamlining code review.
Data analysis – analysts query the hosted database directly from their editor without switching tools.
Team collaboration – shared .gibsonai project files keep team members synchronized on project UUIDs and configurations.

FAQ from the GibsonAI MCP Server

Q: Do I need to install anything besides the Gibson CLI? A: No. The MCP server runs via the gibson mcp run command provided by the CLI.

Q: Which IDEs are supported? A: Cursor, Windsurf, Claude Desktop, VS Code (Copilot chat), and the Cline VS Code extension.

Q: How is authentication handled? A: You must be logged in with gibson auth login; the server reuses the stored token for all API calls.

Q: Can I customize the server command? A: Yes, any client can point to a different command or script as long as it invokes gibson mcp run.

Q: What if I want to run the server locally without internet? A: The server requires access to GibsonAI’s cloud APIs for project and database operations, so an internet connection is necessary.

The GibsonAI Model Context Protocol Server provides a set of tools to MCP Clients like Cursor, Windsurf, or Claude Desktop. These clients can use these tools to interact with your GibsonAI projects and databases using your natural language instructions.

You can accomplish various tasks with GibsonAI directly in your favorite IDE, for example:

Create new GibsonAI projects and design database schemas
View project structure, schema diagrams, a summary of tables and relationships
Apply schema changes and trigger automatic migrations
Run SQL queries against your database
Deploy projects to development or production environments
Seed tables with mock data
Build a full-stack apps

Prompt Examples:

“Create a blogging platform schema with users, posts, and comments.”
“Add a foreign key from bookings to payments.”
“Generate mock data for the boooking destination table.”
“Fetch connection string for my blogging database”
“Explain how the tables are related in this project.”

Usage Examples

Authentication

You'll need to ensure you're logged in to the Gibson CLI before the MCP server will work.

uvx --from gibson-cli@latest gibson auth login

Cursor Setup

Click the Add to Cursor button above or go to Cursor → Settings → Cursor Settings → MCP Tools and click New MCP Server. Update the configuration to include the following:

{
  "mcpServers": {
    "gibson": {
      "command": "uvx",
      "args": ["--from", "gibson-cli@latest", "gibson", "mcp", "run"]
    }
  }
}

Windsurf Setup

Go to Windsurf → Settings → Windsurf Settings → Cascade and click Add server in the Model Context Protocol (MCP) Servers section

In the modal, click Add custom server

Update the configuration to include the following:

{
  "mcpServers": {
    "gibson": {
      "command": "uvx",
      "args": ["--from", "gibson-cli@latest", "gibson", "mcp", "run"]
    }
  }
}

Open the Cascade chat and, if necessary, refresh the MCP servers

Claude Desktop Setup

Go to Claude → Settings → Developer and click Edit Config

Open the claude_desktop_config.json file and update the configuration to include the following:

{
  "mcpServers": {
    "gibson": {
      "command": "uvx",
      "args": ["--from", "gibson-cli@latest", "gibson", "mcp", "run"]
    }
  }
}

See the Claude Desktop MCP docs for more information.

Claude Code Setup

claude mcp add gibson -- uvx --from gibson-cli@latest gibson mcp run

claude mcp get gibson

gibson:
  Scope: Local (private to you in this project)
  Type: stdio
  Command: uvx
  Args: --from gibson-cli@latest gibson mcp run
  Environment:

To remove this server, run: claude mcp remove "gibson" -s local

VS Code + GitHub Copilot Setup

Create or open the .vscode/mcp.json file

Update the configuration to include the following:

{
  "inputs": [],
  "servers": {
    "gibson": {
      "type": "stdio",
      "command": "uvx",
      "args": ["--from", "gibson-cli@latest", "gibson", "mcp", "run"]
    }
  }
}

See the official GitHub Copilot MCP docs for more information.

Cline (VS Code Extension) Setup

Open Cline in VS Code:
Go to Sidebar → Cline icon.
To configure MCP Servers in Cline, you need to modify the cline_mcp_settings.json file. Click the MCP Servers icon → go to Installed → click Configure MCP Servers to open the configuration file.
Add the following gibson server entry inside the mcpServers object:

{
  "mcpServers": {
    "gibson": {
      "command": "uvx",
      "args": ["--from", "gibson-cli@latest", "gibson", "mcp", "run"]
    }
  }
}

Save the file. Cline should reload the configuration automatically.

🔧 Supported Tools

🗂 `get_projects`

Title: List all existing projects
Description: Retrieves all GibsonAI projects associated with the authenticated user. Useful when the user refers to a project by name but you need the UUID. If a .gibsonai file exists, use it instead unless the user intends otherwise.

🆕 `create_project`

Title: Create a new project
Description: Creates a new GibsonAI project. Check for an existing .gibsonai file or similar project names before creation. Prompt the user to update or create the .gibsonai file with the new UUID.

🔍 `get_project_details`

Title: Fetch project metadata
Description: Returns metadata and configuration for a given project using its UUID. Ideal when working with an existing .gibsonai file to load project-specific context.

🔗 `get_project_hosted_database_details`

Title: Get hosted database connection details
Description: Returns credentials, connection string, dialect, and other necessary details for querying the hosted GibsonAI database. Useful for building queries or integrating with tools.

✏️ `update_project`

Title: Rename a project
Description: Updates the project name using its UUID. Currently, only the project_name field is supported.

🧠 `submit_data_modeling_request`

Title: Submit schema modeling request
Description: Submit any natural-language data modeling request (e.g., create, modify schema). This tool fully handles the request using GibsonAI's internal modeler and should be used instead of any manual schema design.

🚀 `deploy_project`

Title: Deploy to database(s)
Description: Triggers automatic schema migrations and deploys the current schema to all GibsonAI supported databases.

📐 `get_project_schema`

Title: Get working schema
Description: Retrieves the current state of the schema including unpublished or un-deployed changes.

✅ `get_deployed_schema`

Title: Get live schema
Description: Fetches the schema currently deployed to the primary hosted database. Use this to compare against the working schema or confirm deployment to your primary database (e.g. Production)

🧾 `query_database`

Title: Run SQL queries
Description: Runs the provided SQL query against a database by using the API key associated with that database. Ensure correct quoting for identifiers depending on the SQL dialect (e.g., backticks for MySQL, double quotes for PostgreSQL).

Distribution

Note that this repo is for documentation purposes only. Our MCP server code lives within our CLI, which allows us to share authentication + API interaction logic with the CLI and have a single distribution. This means we're able to ship new features to you faster.

GibsonAI MCP Server