capabilities.work

Run a SQL query against my data sources

One step with CData. We can help you get access.

Get something done

Run a SQL query against my data sources

with CData

Use CData: its CData Connect AI REST API Embedded Query API lets you run a SQL query against my data sources in a single step (POST /query). capabilities.work can help you get signed up and connected.

  • How do I run a SQL SELECT across the data sources in my CData Connect AI account?
  • Can I get just the result set schema without any data rows?
  • Which SQL statements can a single query request run?
Say it to your AI assistant
  • Run the SQL query {query}.
  • Run {query} using default catalog {defaultCatalog} and return only the result schema when schemaOnly is {schemaOnly}.
For your developer

POST /query in CData Connect AI REST API Embedded Query API. Full spec on APIs.io.

More you can do with CData

List the catalogs (connections) in my accountList the schemas in a catalogList tables and views in a schemaList the columns of a table or viewList a table's primary keysList the keys a table's foreign keys referenceList foreign keys that reference a tableList the indexes on a tableList stored procedures in a schemaList a stored procedure's parametersGet a link to the Data Explorer pageSend an MCP request across all my connections