Skip to content

CONTINUE.md

Latest commit

 

History

History
235 lines (187 loc) · 5.07 KB

CONTINUE.md

File metadata and controls

235 lines (187 loc) · 5.07 KB

Continue Integration Guide

This guide shows how to integrate Universal Database MCP Server with Continue, the open-source AI code assistant.

Overview

Continue is an open-source AI code assistant that runs in VS Code and JetBrains IDEs. It supports MCP, allowing you to connect to databases and query them using natural language.

Key Benefits:

  • Open-source and customizable
  • Native MCP support
  • Works with multiple LLM providers
  • VS Code and JetBrains support

Prerequisites

  • Continue extension installed in VS Code or JetBrains
  • Node.js 20.0.0 or later
  • Database instance accessible from your machine

Configuration

Configuration File Location

Continue uses a configuration file at:

  • All platforms: ~/.continue/config.json

Basic Configuration

Add the MCP server to your config.json:

{
  "mcpServers": [
    {
      "name": "database",
      "command": "npx",
      "args": [
        "universal-db-mcp",
        "--type", "mysql",
        "--host", "localhost",
        "--port", "3306",
        "--user", "root",
        "--password", "your_password",
        "--database", "your_database"
      ]
    }
  ]
}

Configuration Examples

MySQL

{
  "mcpServers": [
    {
      "name": "mysql-dev",
      "command": "npx",
      "args": [
        "universal-db-mcp",
        "--type", "mysql",
        "--host", "localhost",
        "--port", "3306",
        "--user", "root",
        "--password", "password",
        "--database", "myapp"
      ]
    }
  ]
}

PostgreSQL

{
  "mcpServers": [
    {
      "name": "postgres-dev",
      "command": "npx",
      "args": [
        "universal-db-mcp",
        "--type", "postgres",
        "--host", "localhost",
        "--port", "5432",
        "--user", "postgres",
        "--password", "password",
        "--database", "myapp"
      ]
    }
  ]
}

Multiple Databases

{
  "mcpServers": [
    {
      "name": "mysql-users",
      "command": "npx",
      "args": [
        "universal-db-mcp",
        "--type", "mysql",
        "--host", "localhost",
        "--port", "3306",
        "--user", "root",
        "--password", "password",
        "--database", "users_db"
      ]
    },
    {
      "name": "postgres-analytics",
      "command": "npx",
      "args": [
        "universal-db-mcp",
        "--type", "postgres",
        "--host", "localhost",
        "--port", "5432",
        "--user", "postgres",
        "--password", "password",
        "--database", "analytics"
      ]
    }
  ]
}

Usage

Using MCP Tools

  1. Open Continue chat panel
  2. Use the /tools command to see available tools
  3. Ask questions about your database:
What tables are in the database?

Show me the schema of the users table

Generate a TypeScript interface for the orders table

Find all users who signed up this week

Common Workflows

Schema Exploration:

List all tables and their columns
What are the relationships between tables?
Show me the indexes on the products table

Code Generation:

Create a repository class for the users table
Generate SQL migrations for adding a new column
Write a function to get user orders with pagination

Data Analysis:

How many orders were placed this month?
What's the average order value?
Find the top 10 products by sales

Available MCP Tools

Tool Description
execute_query Execute SQL queries
get_schema Get database schema information
get_table_info Get detailed table information
clear_cache Clear schema cache
get_enum_values Get all unique values for a specified column
get_sample_data Get sample data from a table (with automatic data masking)
connect_database Dynamically connect to a database (supports all 17 types)
disconnect_database Disconnect from the current database
get_connection_status Get current database connection status

Best Practices

Security

  1. Use read-only database users
  2. Never commit credentials to version control
  3. Use environment variables for sensitive data
  4. Keep write mode disabled unless necessary

Performance

  1. Use specific queries instead of SELECT *
  2. Add LIMIT to prevent large result sets
  3. Cache schema information

Troubleshooting

MCP Server Not Found

Symptoms: Continue doesn't show database tools

Solutions:

  1. Verify config.json syntax is valid
  2. Check the file is at ~/.continue/config.json
  3. Ensure Node.js 20+ is installed
  4. Restart VS Code/IDE

Connection Failed

Symptoms: Database connection errors

Solutions:

  1. Verify database is running
  2. Check credentials are correct
  3. Ensure network connectivity
  4. Test with database client first

Resources

Support

For integration issues: