Documentation Index Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
Use this file to discover all available pages before exploring further.
Server path: /mssql | Type: Application | PCID required: YesTool Description mssql_get_infoGet Microsoft SQL Server database connection information mssql_list_tablesList all tables in the SQL Server database mssql_describe_tableGet table structure and column information mssql_execute_queryExecute a SQL query on Microsoft SQL Server. Use ? placeholders for parameterized queries (e.g., “SELECT * FROM users WHERE id = ? AND status = ?”). Parameters are applied in order. mssql_select_dataSelect data from a SQL Server table mssql_insert_dataInsert data into a SQL Server table mssql_update_dataUpdate data in a SQL Server table mssql_delete_dataDelete data from a SQL Server table mssql_create_tableCreate a new table in SQL Server
mssql_get_info Get Microsoft SQL Server database connection information
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" } }, "required" : [ "PCID" ] }
mssql_list_tables List all tables in the SQL Server database
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" } }, "required" : [ "PCID" ] }
mssql_describe_table Get table structure and column information
Parameters: Parameter Type Required Default Description tablestring Yes — Table name to describe
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "table" : { "type" : "string" , "description" : "Table name to describe" } }, "required" : [ "PCID" , "table" ] }
mssql_execute_query Execute a SQL query on Microsoft SQL Server. Use ? placeholders for parameterized queries (e.g., “SELECT * FROM users WHERE id = ? AND status = ?”). Parameters are applied in order.
Parameters: Parameter Type Required Default Description querystring Yes — The SQL query to execute. Use ? as placeholders for parameters (e.g., “SELECT * FROM users WHERE id = ?”) parametersstring[] No — Array of parameter values to substitute for ? placeholders in order
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "query" : { "type" : "string" , "description" : "The SQL query to execute. Use ? as placeholders for parameters (e.g., \" SELECT * FROM users WHERE id = ? \" )" }, "parameters" : { "type" : "array" , "items" : { "oneOf" : [ { "type" : "string" }, { "type" : "number" }, { "type" : "boolean" }, { "type" : "null" } ] }, "description" : "Array of parameter values to substitute for ? placeholders in order" } }, "required" : [ "PCID" , "query" ] }
mssql_select_data Select data from a SQL Server table
Parameters: Parameter Type Required Default Description tablestring Yes — Table name columnsstring[] No — Columns to select (defaults to all) wherestring No — WHERE clause conditions orderBystring No — ORDER BY clause limitnumber No — Number of results (uses TOP in SQL Server) offsetnumber No — OFFSET for pagination
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "table" : { "type" : "string" , "description" : "Table name" }, "columns" : { "type" : "array" , "items" : { "type" : "string" }, "description" : "Columns to select (defaults to all)" }, "where" : { "type" : "string" , "description" : "WHERE clause conditions" }, "orderBy" : { "type" : "string" , "description" : "ORDER BY clause" }, "limit" : { "type" : "number" , "description" : "Number of results (uses TOP in SQL Server)" }, "offset" : { "type" : "number" , "description" : "OFFSET for pagination" } }, "required" : [ "PCID" , "table" ] }
mssql_insert_data Insert data into a SQL Server table
Parameters: Parameter Type Required Default Description tablestring Yes — Table name dataobject Yes — Data to insert as key-value pairs (supports nested objects and arrays for JSON columns)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "table" : { "type" : "string" , "description" : "Table name" }, "data" : { "type" : "object" , "additionalProperties" : true , "description" : "Data to insert as key-value pairs (supports nested objects and arrays for JSON columns)" } }, "required" : [ "PCID" , "table" , "data" ] }
mssql_update_data Update data in a SQL Server table
Parameters: Parameter Type Required Default Description tablestring Yes — Table name dataobject Yes — Data to update as key-value pairs (supports nested objects and arrays for JSON columns) wherestring Yes — WHERE clause to identify rows to update
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "table" : { "type" : "string" , "description" : "Table name" }, "data" : { "type" : "object" , "additionalProperties" : true , "description" : "Data to update as key-value pairs (supports nested objects and arrays for JSON columns)" }, "where" : { "type" : "string" , "description" : "WHERE clause to identify rows to update" } }, "required" : [ "PCID" , "table" , "data" , "where" ] }
mssql_delete_data Delete data from a SQL Server table
Parameters: Parameter Type Required Default Description tablestring Yes — Table name wherestring Yes — WHERE clause to identify rows to delete
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "table" : { "type" : "string" , "description" : "Table name" }, "where" : { "type" : "string" , "description" : "WHERE clause to identify rows to delete" } }, "required" : [ "PCID" , "table" , "where" ] }
mssql_create_table Create a new table in SQL Server
Parameters: Parameter Type Required Default Description tableNamestring Yes — Name of the table to create columnsobject[] Yes — Table column definitions
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "tableName" : { "type" : "string" , "description" : "Name of the table to create" }, "columns" : { "type" : "array" , "items" : { "type" : "object" , "properties" : { "name" : { "type" : "string" , "description" : "Column name" }, "type" : { "type" : "string" , "description" : "Column data type (e.g., VARCHAR(255), INT, NVARCHAR(MAX))" }, "nullable" : { "type" : "boolean" , "default" : true , "description" : "Whether column can be NULL" }, "primaryKey" : { "type" : "boolean" , "default" : false , "description" : "Whether column is primary key" }, "autoIncrement" : { "type" : "boolean" , "default" : false , "description" : "Whether column auto-increments (uses IDENTITY)" } } }, "description" : "Table column definitions" } }, "required" : [ "PCID" , "tableName" , "columns" ] }
