SPSync
SPSync copies SharePoint Online lists into SQL Server, PostgreSQL, MySQL and 28 other data stores, read-only, and keeps them in sync with delta queries.
SPSync copies SharePoint Online lists into SQL Server, PostgreSQL, MySQL and 28 other data stores, read-only, and keeps them in sync with delta queries.
This page is designed to help you find out whether SPSync is good and if it is the right choice for you.
SPSync copies SharePoint Online lists into SQL Server, PostgreSQL, MySQL and 28 other data stores, read-only, and keeps them in sync with delta queries.
Power BI reports on SharePoint lists refresh slowly or time out, views stop at the 5,000-item threshold, and joining lists means stitching them together by hand. SPSync keeps a current copy of your lists in a database, so every tool that speaks SQL can read it directly.
SQL Server, Azure SQL, PostgreSQL, MySQL, Oracle, SQLite, Supabase, Dataverse, BigQuery, Databricks, ClickHouse, DuckDB, Delta Lake, Iceberg, Azure AI Search, Elasticsearch, Qdrant and more.
Generated reporting views for Power BI DirectQuery. AI agents query a SQL copy with a database login instead of Graph permissions. Embeddings for pgvector and Azure AI Search, re-embedding only changed rows.
SPSync never writes to SharePoint. Unattended sync uses Sites.Selected, so an admin approves named sites only, and the setup wizard writes the admin a one-page permissions pack.
Desktop app for Apple Silicon Macs and Windows 10 and 11. YAML-driven command line for macOS, Windows and Linux, for schedulers and CI. One licence covers both.
Annual, quote-based licences with unlimited lists and items. Made by EBORACUM IT LTD, London.
Listed in
Sync SharePoint lists to SQL Server and Azure SQL
Replicate SharePoint Online lists into SQL Server and Azure SQL on a schedule, so reports, apps and analysts query ordinary tables instead of SharePoint.
SharePoint lists to PostgreSQL, MySQL and Oracle
The same normalised tables in PostgreSQL, MySQL, MariaDB, Oracle, SQLite, Supabase and Neon, or in Dataverse for Power Apps.
SharePoint to data warehouses and lakehouses
Feed BigQuery, Databricks, ClickHouse, DuckDB, MotherDuck, Delta Lake, Apache Iceberg and Azure Data Lake Storage, with Parquet export to Amazon S3 and Azure Blob.
SharePoint to search and vector databases
Index list items in Azure AI Search, Elasticsearch, OpenSearch, PostgreSQL with pgvector, LanceDB, Qdrant and Weaviate, kept current on every sync.
Incremental delta sync
After one full load, SPSync reads only new, changed and deleted items through Microsoft Graph delta queries, within the tenant’s throttling budget.
No 5,000-item list view threshold
Large lists replicate in full. SPSync reads past the 5,000-item list view threshold, so lists with tens of thousands of items report as easily as small ones.
Power BI reporting views
Generated views for Power BI DirectQuery in SQL Server, PostgreSQL, MySQL, Oracle, BigQuery, Databricks and more, ending slow refreshes on SharePoint lists.
Lookup columns as foreign keys
Lookups become keys, multi-choice and people columns become child tables, and users go into one table, so joining lists is one simple query in your database or warehouse.
Read-only SharePoint access
SPSync never writes to SharePoint. Replication is one-way, from SharePoint Online to your destination, which makes the security review short.
Sites.Selected permissions
Unattended sync uses application permissions scoped with Sites.Selected, so an admin grants access to named sites only, never the whole tenant.
Combine lists from multiple sites
Merge the same list from many SharePoint sites into one table, with the source site on every row, for organisation-wide reporting.
Deleted items kept (soft deletes)
Items deleted in SharePoint stay in the destination, flagged with the time they were deleted, so audit and history questions can still be answered.
Automatic schema changes
When someone adds a column to a SharePoint list, SPSync adds it in the destination on the next run. No pipeline to edit.
Reconcile and outage recovery
A reconcile, weekly by default and configurable, compares SharePoint with the destination and corrects drift: a quality check and recovery after an outage.
A governed copy for AI agents
AI agents, assistants and text-to-SQL tools query a current copy in your own database, holding no SharePoint or Graph permission of their own.
Vector embeddings for RAG
Writes embeddings to pgvector and Azure AI Search on each sync, re-embedding only rows whose text changed, so retrieval indexes stay current.
Document library metadata
Replicates document library metadata (file names, folders, content types and custom columns) as a queryable catalogue for governance and retention.
Command line and YAML for CI
A YAML-driven command line for macOS, Windows and Linux, with exit codes for schedulers and CI pipelines and secrets kept in environment variables.
Desktop app for Mac and Windows
A guided desktop app for Apple Silicon Macs and Windows 10 and 11 that keeps syncing in the background, with per-run metrics for every list.
Admin permissions pack
The first-run permissions wizard produces a one-page pack telling the tenant admin exactly what to grant, for which sites, and why.
Sync a whole site or pick lists
Tick individual lists and libraries, name a list once to select it on every site, or sync a whole site so new lists are included automatically.
Pre-flight checks before the first run
spsync doctor checks SharePoint permissions, connectivity and the destination before anything runs, so problems show up in seconds, not in a failed overnight job.
SPSync does one job: it keeps SharePoint Online lists replicated into the database you already use, and it does that job properly.
Most tools treat SharePoint as one connector among hundreds and produce a flat table with nested columns. SPSync writes normalised tables: lookup columns become foreign keys, multi-choice and people columns become child tables, and deleted items are kept with the time they were deleted.
After the first load it reads only changes through Microsoft Graph delta queries, so large lists stay current without hitting the 5,000-item threshold. It is read-only, scoped per site with Sites.Selected, runs on your own machine or server, and writes to 31 destinations, from SQL Server and PostgreSQL to BigQuery, Databricks and Azure AI Search.
Microsoft Graph API with delta queries, and MSAL for Microsoft Entra ID sign-in
Organisations on Microsoft 365 that hold important working data in SharePoint lists and have outgrown reading it from SharePoint directly. Typically:
Buyers range from mid-sized companies to large enterprises, often in regulated sectors where read-only access and per-site permissions matter.
SPSync came out of years of Microsoft 365 and SharePoint consulting work. The same problem kept appearing: a business had put its working data into SharePoint lists because they were quick to set up and easy for staff to use, and then the reporting broke.
Power BI refreshes timed out, views hit the 5,000-item limit, and someone had built a Power Automate flow or a script to copy the data out, which worked until it quietly stopped. Every fix was a one-off.
SPSync is the tool we wanted on those projects: one supported, read-only way to keep an accurate, current copy of SharePoint lists in a real database, with tables a person or an AI can actually query. It is built by EBORACUM IT LTD in London.
We have collected here some useful links to help you find out if SPSync is good.
Check the traffic stats of SPSync on SimilarWeb. The key metrics to look for are: monthly visits, average visit duration, pages per visit, and traffic by country. Moreoever, check the traffic sources. For example "Direct" traffic is a good sign.
Check the "Domain Rating" of SPSync on Ahrefs. The domain rating is a measure of the strength of a website's backlink profile on a scale from 0 to 100. It shows the strength of SPSync's backlink profile compared to the other websites. In most cases a domain rating of 60+ is considered good and 70+ is considered very good.
Check the "Domain Authority" of SPSync on MOZ. A website's domain authority (DA) is a search engine ranking score that predicts how well a website will rank on search engine result pages (SERPs). It is based on a 100-point logarithmic scale, with higher scores corresponding to a greater likelihood of ranking. This is another useful metric to check if a website is good.
The latest comments about SPSync on Reddit. This can help you find out how popualr the product is and what people think about it.
Do you know an article comparing SPSync to other products?
Suggest a link to a post with product alternatives.
Is SPSync good? This is an informative page that will help you find out. Moreover, you can review and discuss SPSync here. The primary details have been verified within the last quarter. So they could be considered up to date. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.
