Databases
Create powerful queries and perform mutations on any database with the Squid Client SDK.
Squid lets you connect any database and interact with your data using the Squid Client SDK. Whether SQL or NoSQL, you can insert or update data and perform complex queries. You can even perform joins across database connectors, allowing you to connect completely separate data sources with a few lines of code.
The fundamentals
Connectors
You can work with Squid's built-in NoSQL database or an external database by adding it as a connector in your application.
Data organization
Data in Squid is organized through a structure of collections and documents. A collection can be thought of as a table in a SQL database, or a collection of documents in a NoSQL database. A document can be thought of as a row in a table for a SQL database, or a document in a NoSQL database. No matter the data source, you interact with your data using this same structure.
Learn more about collections and documents by reading the documentation on:
Querying and modifying data
To learn about building queries in Squid, view the following guides:
Inserting, updating, and deleting documents is simple using the Client SDK. Follow these guides to find out how to mutate your data:
Query with AI
Squid provides the capability to query any database through natural language using Query with AI. By asking a question about your data, Squid AI generates the query for you and provides the results. You can also use Query with AI to generate charts and graphs of your data, providing insights on the fly without the need to write complex data queries.
To learn more, view the Query with AI documentation.
Explore
📄️ Collection reference
A collection reference enables access to a collection of documents (NoSQL) or a table (SQL) in a database.
📄️ Document IDs
Document IDs are unique identifiers of a document that can be automatically generated by the server or manually specified by the user.
📄️ Document reference
A document reference is a reference to a specific record in a collection. You can use it to read or write data to the document.
📄️ Mutations
Mutations refer to actions that modify the data of a document. They provide a fast and responsive user experience using optimistic updates.
📄️ Native queries
Execute raw SQL or other database-specific queries directly against the database.
📄️ Queries
Create fine-grained queries for your data from any source, including joining data across multiple databases with real-time query support.
📄️ Transactions
Perform multiple mutations on one or more documents in an atomic manner for better performance at scale.