• OBJECTS
  • FIELDS
  • SCHEMA
  • HUMAN

How to inspect Knack database schema with your AI

Connect your AI to Knack once. After that, your agent knows your data structure inside and out.

Ask AI about this page

Short answer

How can my AI see my Knack database structure?

Your AI uses this connector to pull a list of all objects and their specific field names. It builds a map of your data so it can interact with your records correctly. You get a clear view of your schema through direct interrogation.

The results.

What your AI discovers.

The AI maps your Knack environment so it knows where everything lives.

OBJECTS

Identify all tables

The AI finds every object in your Knack app. It learns the names of your tables so it knows which ones to target.

FIELDS

Map field names

It looks inside each object to find the exact field keys. This prevents errors when you ask the AI to update specific data.

SCHEMA

Understand data types

The agent learns how your data is organized. It understands how different objects and fields relate to each other.

HUMAN

Verify the map

You review what the AI found. You decide if the mapping is correct before you run any data operations.

The workflow

What your AI does when the connection is live.

The AI moves from a high-level view of your app down to the specific details of every field.

  1. List all objects

    The AI scans your Knack application to find every available object. This gives it a bird's-eye view of your database.

    list_objects

  2. Check object details

    Once it finds an object, the AI looks at its specific schema. It identifies the underlying structure of that table.

    get_object_schema

  3. Identify field keys

    The AI drills down into the individual fields within an object. It grabs the exact field names needed for precise interaction.

    list_object_fields

  4. Build a data map

    The agent combines these details into a coherent understanding. It now knows exactly which keys to use for your requests.

    list_objectsget_object_schema

Try it

Copy these to start.

Use these prompts to begin exploring your Knack data.

Starting points

These are opening lines. Swap out the object names for the actual ones in your Knack app.

Knack Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_8zkaxFp7kroPXR5bPCZcLTjzvvjnB0tvy386FSph/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 — Knack capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "knack-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_8zkaxFp7kroPXR5bPCZcLTjzvvjnB0tvy386FSph/mcp"
    }
  }
}
Copy into chat04

  • List all the objects in my Knack database so I can see what's available.

  • Show me the schema for the 'Invoices' object so I know the field names.

  • What are the field names for the 'Customer Contacts' object?

  • Check the structure of my 'Project Tracker' object to see how it's built.

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

Start here

Connect Knack once, then ask.

One connection is all it takes. Your credentials stay encrypted and secure, and you can find the full setup guide on the Connector page.

Connect Knack to your AI

FAQ

How this task behaves.

  • 01

    Can the AI change my Knack field names?

    No. The AI can only read the schema to understand it. It cannot modify your Knack application structure.

  • 02

    Will the AI delete any of my data while inspecting the schema?

    No. The tools used for inspection are read-only. Your data remains untouched.

  • 03

    Does the AI see all my data or just the structure?

    During schema inspection, the AI only looks at the names of objects and fields. It does not pull your actual record data unless you specifically ask it to.

  • 04

    How does the AI know which field is a text field versus a number field?

    It uses the schema information to identify the data types assigned to each field in your Knack app.

  • 05

    Can I use this to find hidden fields?

    Yes. If the field exists in your Knack object, the AI can find it using the schema tools.

  • More questions about Knack? See everything the Knack Connector can do

Connect Knack to Claude, Cursor, ChatGPT & more