im using the the following on mac
{
"version": "1.0.0",
"mcpServers": {
"sql-explorer": {
"name": "SQL Database Explorer",
"version": "1.0.0",
"description": "SQLite database explorer with comprehensive query capabilities",
"command": "npx",
"args": ["-y", "ts-node", "server.ts", "--stdio"],
"env": {
"DATABASE_URL": "postgresql://db_user:db_pwd123@localhost:5477/qaworld?schema=public"
},
"capabilities": {
"resources": {
"schema": {
"description": "Get schema information for database objects",
"uriTemplate": "schema://{object}",
"parameters": {
"object": {
"type": "string",
"description": "Name of the database object (table, view, etc.)"
}
}
},
"table-preview": {
"description": "Preview data from a table",
"uriTemplate": "preview://{table}",
"parameters": {
"table": {
"type": "string",
"description": "Name of the table to preview"
}
}
}
},
"tools": {
"list_tables": {
"description": "Get a list of all tables in the database",
"parameters": {}
},
"describe_table": {
"description": "View schema information for a specific table",
"parameters": {
"table_name": {
"type": "string",
"description": "Name of the table"
}
}
},
"query": {
"description": "Execute SQL queries",
"parameters": {
"sql": {
"type": "string",
"description": "SQL query to execute"
}
}
},
"count-records": {
"description": "Count records in a table",
"parameters": {
"table": {
"type": "string",
"description": "Name of the table"
},
"where": {
"type": "string",
"description": "Optional WHERE clause",
"required": false
}
}
},
"insert-data": {
"description": "Insert data into a table",
"parameters": {
"table": {
"type": "string",
"description": "Target table name"
},
"data": {
"type": "object",
"description": "Data to insert (JSON object)"
}
}
},
"update-data": {
"description": "Update data in a table",
"parameters": {
"table": {
"type": "string",
"description": "Target table name"
},
"set": {
"type": "object",
"description": "Update values (JSON object)"
},
"where": {
"type": "string",
"description": "WHERE clause for the update"
}
}
},
"delete-data": {
"description": "Delete data from a table",
"parameters": {
"table": {
"type": "string",
"description": "Target table name"
},
"where": {
"type": "string",
"description": "WHERE clause for deletion"
}
}
}
}
}
}
},
"defaultServer": "sql-explorer",
"settings": {
"timeout": 30000,
"retryAttempts": 3,
"logLevel": "info"
}
}
still facing the same issue