How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

LanceDB Table API

Operations that are related to a table

LanceDB Table API is one of 16 APIs that LanceDB publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Table. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, a getting-started guide, and release notes.

This API exposes 41 operations across 41 paths, and defines 97 schemas. It is described by OpenAPI 3.1.1, at version 1.0.0.

Requests are made against 2 base URLs: {scheme}://{host}:{port}/{basePath}, {scheme}://{host}/{basePath}.

41 operations 41 paths 97 schemas 2 GET39 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.1.1
API Version
1.0.0
Base URL
https://github.com/lancedb/lancedb
Authentication
OAuth 2.0, HTTP Bearer, API Key
License
Resource Areas
1

Authentication & Security 3

LanceDB Table API declares 3 security schemes for authenticating requests. It supports OAuth 2.0 (OAuth2) using the clientCredentials flow. It accepts HTTP bearer tokens (BearerAuth). An API key is passed in the header as x-api-key (ApiKeyAuth). By default, every request must be authenticated.

Paths & Operations 41

Across 41 paths, the API surfaces 41 operations — 2 GET, 39 POST. Each is listed below with its method, path, parameters, and response codes.

Table 41

Operations that are related to a table

GET
/v1/namespace/{id}/table/list
List tables in a namespace
ListTables 5 params → 2004004014034044065035XX
GET
/v1/table
List all tables
ListAllTables 4 params → 2004004014035035XX
POST
/v1/table/{id}/register
Register a table to a namespace
RegisterTable 2 params body → 200400401403404406409503
POST
/v1/table/{id}/describe
Describe information of a table
DescribeTable 5 params body → 2004004014034045035XX
POST
/v1/table/{id}/exists
Check if a table exists
TableExists 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/drop
Drop a table
DropTable 2 params → 2004004014034045035XX
POST
/v1/table/{id}/deregister
Deregister a table
DeregisterTable 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/restore
Restore table to a specific version
RestoreTable 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/rename
Rename a table
RenameTable 2 params body → 2004004014034044095035XX
POST
/v1/table/{id}/schema_metadata/update
Update table schema metadata
UpdateTableSchemaMetadata 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/version/list
List all versions of a table
ListTableVersions 5 params → 2004004014034045035XX
POST
/v1/table/{id}/version/create
Create a new table version
CreateTableVersion 2 params body → 2004004014034044095035XX
POST
/v1/table/{id}/version/describe
Describe a specific table version
DescribeTableVersion 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/version/delete
Delete table version records
BatchDeleteTableVersions 2 params body → 2004004014034045035XX
POST
/v1/table/version/batch-create
Atomically create versions for multiple tables
BatchCreateTableVersions 1 param body → 2004004014034044095035XX
POST
/v1/table/batch-commit
Atomically commit a batch of mixed table operations
BatchCommitTables 1 param body → 2004004014034044095035XX
POST
/v1/table/{id}/alter_columns
Modify existing columns
AlterTableAlterColumns 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/drop_columns
Remove columns from table
AlterTableDropColumns 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/stats
Get table statistics
GetTableStats 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/insert
Insert records into a table
InsertIntoTable 3 params body → 2004004014034045035XX
POST
/v1/table/{id}/merge_insert
Merge insert (upsert) records into a table
MergeInsertIntoTable 10 params body → 2004004014034045035XX
POST
/v1/table/{id}/update
Update rows in a table
UpdateTable 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/delete
Delete rows from a table
DeleteFromTable 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/query
Query a table
QueryTable 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/count_rows
Count rows in a table
CountTableRows 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/create
Create a table with the given name
CreateTable 5 params body → 2004004014034044095035XX
POST
/v1/table/{id}/explain_plan
Get query execution plan explanation
ExplainTableQueryPlan 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/analyze_plan
Analyze query execution plan
AnalyzeTableQueryPlan 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/add_columns
Add new columns to table schema
AlterTableAddColumns 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/backfill_column
Trigger an async column backfill job
AlterTableBackfillColumns 2 params body → 2024004014034045035XX
POST
/v1/table/{id}/create_index
Create an index on a table
CreateTableIndex 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/create_scalar_index
Create a scalar index on a table
CreateTableScalarIndex 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/index/list
List indexes on a table
ListTableIndices 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/index/{index_name}/stats
Get table index statistics
DescribeTableIndexStats 3 params body → 2004004014034045035XX
POST
/v1/table/{id}/index/{index_name}/drop
Drop a specific index
DropTableIndex 3 params → 2004004014034045035XX
POST
/v1/table/{id}/tags/list
List all tags for a table
ListTableTags 4 params → 2004004014034045035XX
POST
/v1/table/{id}/tags/version
Get version for a specific tag
GetTableTagVersion 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/declare
Declare a table
DeclareTable 2 params body → 2004004014034044095035XX
POST
/v1/table/{id}/tags/create
Create a new tag
CreateTableTag 2 params body → 2004004014034044095035XX
POST
/v1/table/{id}/tags/delete
Delete a tag
DeleteTableTag 2 params body → 2004004014034045035XX
POST
/v1/table/{id}/tags/update
Update a tag to point to a different version
UpdateTableTag 2 params body → 2004004014034045035XX

Schemas 97

The contract defines 97 schemas that model the data the API accepts and returns. The most detailed are AnalyzeTableQueryPlanRequest (21 properties), QueryTableRequest (21 properties), AlterTableBackfillColumnsRequest (16 properties), CreateTableIndexRequest (15 properties). Each schema is shown below with its type and property counts.

CountTableRowsResponse
integer
Response containing the count of rows. Serializes transparently as just the number for backward compatibility.
AlterTableDropColumnsResponse
object
2 properties 1 required
UpdateTableTagResponse
object
Response for update tag operation
1 property
TagContents
object
3 properties 2 required
GetTableTagVersionRequest
object
4 properties 1 required
ManifestNamingScheme
string
The naming scheme used for manifest files in the versions/ directory. Known values: - V1: versions/{version}.manifest - Simple version-based naming - V2: versi…
ListTableIndicesRequest
object
6 properties
IndexContent
object
4 properties 4 required
DescribeTableVersionResponse
object
Response containing the table version information
1 property 1 required
DescribeTableIndexStatsResponse
object
5 properties
DeregisterTableRequest
object
The table content remains available in the storage.
3 properties
RenameTableRequest
object
5 properties 1 required
AlterTableBackfillColumnsResponse
object
1 property 1 required
CommitTableResult
object
Result of a single operation within a batch commit. Each result corresponds to one operation in the request, in the same order. Exactly one of the result field…
4 properties
VersionRange
object
A range of versions to delete (start inclusive, end exclusive). Special values: - startversion: 0 with endversion: -1 means ALL versions
2 properties 2 required
JsonArrowDataType
object
JSON representation of an Apache Arrow DataType
3 properties 1 required
ErrorResponse
object
Common JSON error response model
4 properties 1 required
MultiMatchQuery
object
1 property 1 required
AlterColumnsEntry
object
5 properties 1 required
DeleteTableTagResponse
object
Response for delete tag operation
1 property
ExplainTableQueryPlanRequest
object
5 properties 1 required
JsonArrowSchema
object
JSON representation of a Apache Arrow schema.
2 properties 1 required
DropTableIndexResponse
object
Response for drop index operation
1 property
RestoreTableResponse
object
Response for restore table operation
1 property
AlterTableAddColumnsRequest
object
3 properties 1 required
DeclareTableResponse
object
Response for declaring a table.
5 properties
TableExistsRequest
object
4 properties
AddColumnsEntry
object
3 properties 1 required
BatchDeleteTableVersionsResponse
object
Response for deleting table version records
2 properties
AddVirtualColumnEntry
object
11 properties 6 required
QueryTableRequest
object
21 properties 2 required
UpdateTableResponse
object
4 properties 2 required
CommitTableOperation
object
A single operation within a batch commit. Provide exactly one of the operation fields to specify the operation kind.
4 properties
BatchCommitTablesRequest
object
Request to atomically commit a batch of table operations. This replaces BatchCreateTableVersionsRequest with a more general interface that supports mixed opera…
3 properties 1 required
BatchDeleteTableVersionsRequest
object
Request to delete table version records. Supports deleting ranges of versions for efficient bulk cleanup.
4 properties 1 required
DeleteFromTableRequest
object
Delete data from table based on a SQL predicate. Returns the number of rows that were deleted.
4 properties 1 required
DeleteTableTagRequest
object
4 properties 1 required
CreateTableVersionResponse
object
Response for creating a table version
2 properties
FragmentStats
object
3 properties 3 required
ListTablesResponse
object
2 properties 1 required
CreateTableIndexResponse
object
Response for create index operation
1 property
MergeInsertIntoTableResponse
object
Response from merge insert operation
5 properties
RestoreTableRequest
object
4 properties 1 required
RegisterTableRequest
object
6 properties 1 required
ListTableIndicesResponse
object
2 properties 1 required
CreateTableResponse
object
5 properties
DeclareTableRequest
object
Request for declaring a table.
6 properties
AlterVirtualColumnEntry
object
10 properties
DescribeTableRequest
object
8 properties
DeleteFromTableResponse
object
2 properties
DescribeTableResponse
object
12 properties
FtsQuery
object
Full-text search query. Exactly one query type field must be provided. This structure follows the same pattern as AlterTransactionAction to minimize difference…
5 properties
BatchCreateTableVersionsResponse
object
Response for batch creating table versions. Contains the created versions for each table in the same order as the request.
2 properties 1 required
CreateTableIndexRequest
object
15 properties 2 required
AlterTableAlterColumnsRequest
object
3 properties 1 required
AlterTableBackfillColumnsRequest
object
16 properties 1 required
Identity
object
Identity information of a request.
2 properties
CreateTableTagResponse
object
Response for create tag operation
1 property
RegisterTableResponse
object
3 properties
DropTableResponse
object
4 properties
DescribeTableIndexStatsRequest
object
5 properties
UpdateTableRequest
object
Each update consists of a column name and an SQL expression that will be evaluated against the current row's value. Optionally, a predicate can be provided to…
6 properties 1 required
StringFtsQuery
object
2 properties 1 required
GetTableStatsResponse
object
4 properties 4 required
CreateTableTagRequest
object
5 properties 2 required
CreateTableScalarIndexResponse
object
Response for create scalar index operation
1 property
StructuredFtsQuery
object
1 property 1 required
BooleanQuery
object
Boolean query with must, should, and mustnot clauses
3 properties 3 required
PageToken
string
An opaque token that allows pagination for list operations (e.g. ListNamespaces). For an initial request of a list operation, if the implementation cannot retu…
DeregisterTableResponse
object
4 properties
MatchQuery
object
7 properties 1 required
PhraseQuery
object
3 properties 1 required
FragmentSummary
object
7 properties 7 required
RenameTableResponse
object
1 property
AlterTableAlterColumnsResponse
object
1 property 1 required
BoostQuery
object
Boost query that scores documents matching positive query higher and negative query lower
3 properties 2 required
DescribeTableVersionRequest
object
Request to describe a specific table version
4 properties
ListTableTagsResponse
object
Response containing table tags
2 properties 1 required
JsonArrowField
object
JSON representation of an Apache Arrow field.
4 properties 3 required
AlterTableDropColumnsRequest
object
4 properties 1 required
TableVersion
object
6 properties 2 required
GetTableStatsRequest
object
3 properties
BatchCommitTablesResponse
object
Response for a batch commit of table operations. Contains the results of each operation in the same order as the request.
2 properties 1 required
UpdateTableTagRequest
object
5 properties 2 required
CountTableRowsRequest
object
5 properties
Operator
string
The operator to use for combining terms. Case insensitive, supports both PascalCase and snakecase. Valid values are: - And: All terms must match. - Or: At leas…
AnalyzeTableQueryPlanRequest
object
21 properties 2 required
Context
object
Arbitrary context for a request as key-value pairs. How to use the context is custom to the specific implementation. REST NAMESPACE ONLY Context entries are pa…
InsertIntoTableResponse
object
Response from inserting records into a table
1 property
ListTableVersionsResponse
object
2 properties 1 required
BatchCreateTableVersionsRequest
object
Request to atomically create new version entries for multiple tables. The operation is atomic: all versions are created or none are.
3 properties 1 required
CreateTableVersionRequest
object
Request to create a new table version entry. This supports putifnotexists semantics, where the operation fails if the version already exists.
9 properties 2 required
AlterTableAddColumnsResponse
object
1 property 1 required
TableBasicStats
object
2 properties 2 required
PageLimit
integer
An inclusive upper bound of the number of results that a caller will receive.
CreateTableVersionEntry
object
An entry for creating a new table version in a batch operation. This supports putifnotexists semantics, where the operation fails if the version already exists.
7 properties 3 required
GetTableTagVersionResponse
object
1 property 1 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

lancedb-table-api-openapi.yml Raw ↑

Other APIs LanceDB publishes across the network.

LanceDB Enterprise
Lance Format
LanceDB Python SDK
LanceDB TypeScript SDK
LanceDB Rust SDK
LanceDB Go SDK
LanceDB C Bindings
LanceDB MCP Server
LanceDB Data API
LanceDB Index API
LanceDB MaterializedView API
LanceDB Metadata API
Where this information came from

This is an independent, third-party profile of LanceDB Table API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.