Elysia Tools Docs
EN
Language
ZHESPTRUFRDEEN
Back to site
Browse tools

Data Processing

Foreign Key Validator

Validate foreign key relationships between multiple datasets. Perfect for checking data integrity, finding orphaned records, and ensuring referential consistency across related tables. Features: - Validate foreign key relationships - Find orphaned records - Check referential integrity - Support multiple key formats - Cross-table validation - Missing key detection - Duplicate key analysis - Relationship mapping Common Use Cases: - Database integrity checks - Data migration validation - ETL process verification - Referential consistency checks - Data quality assurance - Relationship analysis

text· Text resultOpen tool

Quick start

Call this tool from your code in three languages.

cURL
curl -X POST 'https://api.elysiatools.com/en/api/tools/data-foreign-key-validator' \
  -H 'Content-Type: application/json' \
  -d '{"primaryKeyData":"Paste primary key data (parent table)...\nExample:\nID,Name,City\n1,New York,USA\n2,Los Angeles,USA","primaryKeyColumn":1,"foreignKeyData":"Paste foreign key data (child table)...\nExample:\nID,Name,CityID\nJohn,1,1\nJane,2,2","foreignKeyColumn":1,"validationMode":"all","caseSensitive":true,"ignoreEmpty":true,"outputFormat":"detailed"}'

© 2026 Elysia Tools. Developer documentation.

Back to siteBrowse tools

API reference

Send a POST request with your inputs as JSON. File parameters require a separate upload first.

Endpoint

HTTP
POST https://api.elysiatools.com/en/api/tools/data-foreign-key-validator

Parameters

NameTypeRequiredDescription
primaryKeyDatatextareaYes—
primaryKeyColumnnumberYesColumn number that contains the primary key values (1-based index)
foreignKeyDatatextareaYes—
foreignKeyColumnnumberYesColumn number that contains the foreign key values (1-based index)
validationModeselectYes—
caseSensitivecheckboxNoTreat uppercase and lowercase as different values
ignoreEmptycheckboxNoSkip empty or null values during validation
outputFormatselectYes—

Response format

Text result

JSON
{
  "result": "Processed text content",
  "error": "Error message (optional)",
  "message": "Notification message (optional)",
  "metadata": {
    "key": "value"
  }
}

MCP integration

Add this tool to your Model Context Protocol server so AI agents can list and call it.

Server configuration

Add this block to your MCP client configuration:

mcp.json
{
  "mcpServers": {
    "elysiatools-data-foreign-key-validator": {
      "name": "data-foreign-key-validator",
      "description": "Validate foreign key relationships between multiple datasets. Perfect for checking data integrity, finding orphaned records, and ensuring referential consistency across related tables.\n\nFeatures:\n- Validate foreign key relationships\n- Find orphaned records\n- Check referential integrity\n- Support multiple key formats\n- Cross-table validation\n- Missing key detection\n- Duplicate key analysis\n- Relationship mapping\n\nCommon Use Cases:\n- Database integrity checks\n- Data migration validation\n- ETL process verification\n- Referential consistency checks\n- Data quality assurance\n- Relationship analysis",
      "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=data-foreign-key-validator",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

List available tools

After connecting to the SSE endpoint, list the exposed tools:

tools/list
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/list"
}

Call this tool

Invoke the tool by its id, passing arguments built from its parameters:

tools/call
{
  "jsonrpc": "2.0",
  "id": 2,
  "method": "tools/call",
  "params": {
    "name": "data-foreign-key-validator",
    "arguments": {
  "primaryKeyData": "Paste primary key data (parent table)...\nExample:\nID,Name,City\n1,New York,USA\n2,Los Angeles,USA",
  "primaryKeyColumn": 1,
  "foreignKeyData": "Paste foreign key data (child table)...\nExample:\nID,Name,CityID\nJohn,1,1\nJane,2,2",
  "foreignKeyColumn": 1,
  "validationMode": "all",
  "caseSensitive": true,
  "ignoreEmpty": true,
  "outputFormat": "detailed"
}
  }
}
Chain multiple tools in one session with a comma-separated toolId list, e.g. /mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp (max 20).

Questions or issues? Contact [email protected]

Browse tools
Open tool