• DISCOVERY
  • RETRIEVAL
  • ANALYSIS
  • HUMAN

How to query 4D database records with your AI

Connect your 4D environment to your AI client once. From there, you can pull data or explore your schema just by asking.

Ask AI about this page

Short answer

Can I query my 4D database with AI?

Yes. You can use natural language to find specific records, list your database entities, or explore your data catalog. You'll get the specific data subsets you need without writing manual queries.

Data outcomes

Where your data goes

The AI uses specific tools to navigate your database and pull information.

DISCOVERY

Map your schema

The AI looks through your database structure to understand what tables and fields are available for querying.

RETRIEVAL

Pull specific records

Your agent finds and reads the exact data entries you ask for, turning a text question into a data lookup.

ANALYSIS

Summarize data subsets

Once the data is pulled, your AI client can interpret the results or answer questions about the values found.

HUMAN

Verify and act

You review the data the AI found to ensure it's correct before you use it for reports or further decisions.

The workflow

What your AI does when you ask a question.

The AI follows a logical path to turn your request into a precise data retrieval.

  1. Explore the schema

    The AI first checks what data is actually available in your 4D environment to understand the context.

    get_catalog

  2. Identify targets

    It identifies the specific tables or entities that contain the information you're looking for.

    list_entities

  3. Fetch the data

    The AI pulls the specific record or data point requested from the database.

    get_entity

  4. Present results

    The AI translates the raw database information into a readable format for you to use.

    get_entity

Try it

Copy these to start.

Use these prompts to begin interacting with your 4D data.

Starting points

These are opening lines, not scripts. Swap out the bracketed text with your actual table or field names.

4D Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_D1Grnbj5YYTUrRV7JM7mu8HcpMzBi59V8AcgtrDo/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — 4D capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "4d-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_D1Grnbj5YYTUrRV7JM7mu8HcpMzBi59V8AcgtrDo/mcp"
    }
  }
}
Copy into chat04

  • Show me a list of all entities in my 4D database.

  • Find the record for the customer named 'Acme Corp' in the clients table.

  • What tables are available in my 4D environment?

  • Get the details for the order with ID 55092.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect 4D once, then ask.

Follow the link to connect your 4D environment. Your credentials stay encrypted on our side, and the full walkthrough lives on the Connector page.

Connect 4D to your AI

FAQ

How the 4D Connector behaves

  • 01

    Can the AI change or delete my 4D records?

    No. This Connector only provides tools to read and list data. It cannot modify, delete, or add any records to your database.

  • 02

    Does the AI see my entire database at once?

    No. The AI only accesses the specific entities or records it needs to answer your specific question.

  • 03

    Can I use this with Claude or Cursor?

    Yes. Any MCP-compatible client like Claude, Cursor, or Windsurf can use this once you've connected it.

  • 04

    How does the AI know which tables exist?

    It uses the catalog tool to scan your 4D environment and build a map of available entities.

  • 05

    Do I need to write SQL to get data?

    No. You just ask questions in plain English, and the AI handles the technical lookup for you.

  • More questions about 4D? See everything the 4D Connector can do

Connect 4D to Claude, Cursor, ChatGPT & more