NLSQL

npm package for NL to SQL MCP server

python

3

GitHub Stars

python

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "tushar-badhwar-nlsql-mcp-server-npm": {
      "command": "npx",
      "args": [
        "nlsql-mcp-server",
        "start"
      ],
      "env": {
        "OPENAI_API_KEY": "sk-your-actual-api-key-here"
      }
    }
  }
}

You deploy the NLSQL MCP Server to translate natural language queries into SQL, enabling AI-powered multi-agent processing that works across multiple databases. This server acts as a bridge between your client applications and your database backends, letting you ask questions in plain language and receive safe, executable SQL queries.

How to use

Use this MCP server with any compatible MCP client to turn natural language questions into SQL queries and execute them safely. Start by launching the server from your command line or via a client integration, then connect your MCP client to the local server. You can connect to built-in sample data or your own databases, ask questions in natural language, and receive structured SQL results with validation and error handling performed automatically.

Available tools

connect_database

Connect to SQLite, PostgreSQL, or MySQL databases so the MCP server can issue queries against them.

connect_sample_database

Connect to the built-in NBA sample database for testing and demonstrations.

natural_language_to_sql

Convert natural language questions into SQL queries using AI-powered reasoning.

execute_sql_query

Safely execute SQL queries against the connected database and return results.

analyze_schema

AI-powered analysis of the database schema to suggest useful queries and insights.

get_database_info

Retrieve information about tables, columns, and data types in the connected database.

validate_sql_query

Validate the syntax and safety of SQL queries before execution.

get_table_sample

Fetch sample rows from database tables to preview data.

get_connection_status

Check the current connection status to the database.

disconnect_database

Disconnect from the currently connected database.