Who is this guide for?

Designer using Windows tools

You design or manage schemas with SQL Server Management Studio and want to check first that the PC’s operating system is suitable. Microsoft Learn sets out the system requirements for SSMS 22.

Builder of local test environments

You want to run databases or possibly containers locally as well as work with schemas. The requirements of the software you install determine which configuration you need to check; Microsoft Learn and Docker Docs set these out for each application.

Designer with limited desk space

You use suitable schema and management tools, but also want to know how compact the desktop is, which display connections it has and which components you’ll need to buy separately.

What should you look for?

Windows desktop

A good fit if: you want to use SQL Server Management Studio locally and choose a version of Windows supported by Microsoft.

Consider: with a compact PC, check the configuration, upgrade options, display ports and included accessories.

macOS desktop

A good fit if: you work on schemas with software that supports macOS, such as pgAdmin, and don’t rely on using SSMS locally.

Consider: decide in advance which memory and storage configuration will suit your planned test environment; according to Microsoft, SSMS runs on Windows.

What to consider What should you check? Who is this important for?
Compatibility with database tools Make a note of the exact tools and versions. Check the operating system; only check server requirements if you’re installing that server locally. If I don’t want to change how I work with my regular management tool, I’ll first check which operating systems it supports. Around 36% of consumers prioritise tool compatibility.
Local databases and running tasks together Decide which database server and any container environment you’ll use locally. Compare the requirements for the relevant versions with the PC’s configuration. If I also want to test locally as well as work on schemas, I want to know which software will actually run at the same time and what it needs. Around 29% of consumers prioritise local testing capabilities.
A compact, complete workstation Check the display ports on the exact configuration and whether a monitor, keyboard and mouse are included. If I have limited desk space, I also want to know whether the PC will connect to my displays and which components I still need. Around 21% of consumers are looking for a compact, complete workstation.
Upgrading later Check which memory and storage configurations the model supports and what service terms apply. If I might want to upgrade the memory or storage later, I’ll check in advance which upgrades are possible on the specific model. Around 14% of consumers prioritise future upgrades.

Common pitfalls

  • Choosing a processor before checking your database tool

    A desktop won’t necessarily suit the way you work if its operating system doesn’t support the tool you want to use. Microsoft describes SSMS as Windows software; pgAdmin is also available as a desktop app for macOS and Linux.

    Make a note of the exact tool and version, then choose your operating system and PC configuration.

  • Assuming schema design means you need a local server environment

    Designing a schema doesn’t automatically mean you’ll also install a full database server or containers on the same PC. That software has its own requirements, which only matter if you want to run it locally.

    Separate the tools you use just for design from the software you’ll actually install locally.

  • Assuming a mini PC is a complete workstation

    For the Lenovo ThinkCentre M70q Gen 5 Tiny configuration reviewed, the monitor is sold separately, according to Lenovo Netherlands.

    Before ordering, check the box contents, display ports and cables you’ll need for the exact configuration.

Brands to consider

Lenovo

The ThinkCentre M-series Tiny is a compact range of Windows desktops. Lenovo Netherlands lists Windows 11 Pro, 16 GB of memory and a 512 GB SSD for configuration 12TD0017MH.

  • Lenovo says that the memory and storage in the M70q Gen 5 Tiny reviewed can be accessed without tools.
  • The monitor is sold separately for this configuration. Check the exact specifications; these features don’t necessarily apply to every ThinkCentre model.

HP

HP offers compact business desktop configurations. For the HP ProDesk 4 Mini G1i with code E59BWEA#ABH, HP Netherlands lists Windows 11 Pro, 24 GB of RAM and a 512 GB SSD.

  • The configuration listed combines a compact size with the stated memory and storage specifications.
  • These specifications alone don’t tell you how quickly it will run databases. Compare the exact product code and included service with the configuration you’re considering.

Apple

The Mac mini is a compact macOS option for tools that support macOS. Apple Netherlands lists M6 configurations with 16 GB of unified memory and configurable memory and storage options.

  • Apple provides details of display support and configurable memory and storage options for each configuration.
  • Microsoft lists Windows as the operating system for SSMS. So don’t choose a Mac if your workflow depends on using SSMS locally.

Dell

Dell offers OptiPlex desktops in different form factors, including compact models, so you can compare configurations.

  • The available product ranges include different desktop designs to compare against your workspace.
  • Range information doesn’t demonstrate a specific performance advantage or identical specifications. For a particular model, check the operating system, memory, storage, ports and service.

Desktops at Joybuy

These Joybuy products include compact Windows desktops and Mac mini configurations running macOS. Choose according to the software you use and the memory and storage configuration that suits your local testing needs.

SOYO Y5Pro mini PC, Intel Core i5-8250U/8350U, 8 GB DDR4 and 256 GB SATA SSD

SOYO Y5Pro mini PC, Intel Core i5-8250U/8350U, 8 GB DDR4, 256 GB SATA SSD

A Windows 11 mini PC to consider if you’re looking for a compact desktop for schema work; check that the listed configuration suits your tools and workflow.

The product name lists 8 GB DDR4 and a 256 GB SATA SSD. The processor designation is Intel Core i5-8250U/8350U; check which version you’ll receive.

View at Joybuy
Apple Mac mini M6 with 16 GB of memory and 256 GB SSD

Apple Mac mini M6, 16 GB, 256 GB SSD

A macOS desktop for schema work with compatible tools such as pgAdmin; not suitable if you depend on using SQL Server Management Studio locally.

The product name lists an M6 chip with a 12-core CPU and 12-core GPU, 16 GB of memory and a 256 GB SSD.

View at Joybuy
Apple Mac mini M6 with 16 GB of memory and 512 GB SSD

Apple Mac mini M6, 16 GB, 512 GB SSD

A macOS desktop for schema work with compatible tools such as pgAdmin; not suitable if you depend on using SQL Server Management Studio locally.

The product name lists an M6 chip with a 12-core CPU and 12-core GPU, 16 GB of memory and a 512 GB SSD.

View at Joybuy
Apple Mac mini M6 with 24 GB of memory and 512 GB SSD

Apple Mac mini M6, 24 GB, 512 GB SSD

A macOS desktop for schema work with compatible tools such as pgAdmin; not suitable if you depend on using SQL Server Management Studio locally.

The product description lists 24 GB of memory and a 512 GB SSD. This configuration is based on the M6 Mac mini.

View at Joybuy
Lenovo Yoga Mini 01IPH11 Copilot+ PC with 16 GB and 512 GB SSD

Lenovo Yoga Mini 01IPH11 Copilot+ PC, 16 GB, 512 GB SSD

A Windows 11 Home mini desktop to consider for Windows tools; check that the edition and other PC requirements suit the software you plan to use.

The product name lists an Intel Core Ultra 5 325, 16 GB LPDDR5X and a 512 GB PCIe 4.0 SSD.

View at Joybuy

Frequently asked questions

Do I need a separate graphics card to design database schemas?

The requirements cited for SSMS, pgAdmin and SQL Server don’t make a separate graphics card a general requirement for this task. First decide which tools you’ll use, whether you’ll test locally and which display connections you need. This doesn’t guarantee any particular performance from a specific integrated graphics chip.

Can I install Docker Desktop on a Windows mini PC without checking anything else?

No. Check the requirements for your version of Windows, the backend you’ve chosen and your PC’s settings first. Docker Docs lists several backends, including WSL 2 as the default option; this only matters if you actually want to use containers.

Which extra components should I check with a compact desktop?

Check whether a monitor, keyboard and mouse are included, and whether your existing display will work with the ports on the exact configuration. Lenovo Netherlands says the monitor is sold separately for the ThinkCentre M70q Gen 5 Tiny configuration reviewed.

What warranty and cooling-off period apply to an online consumer purchase in the Netherlands?

According to ACM ConsuWijzer, in addition to any retailer or manufacturer’s warranty, you’re entitled to a product that meets your reasonable expectations; there isn’t one fixed period of statutory warranty for all PCs. For online consumer purchases, a statutory cooling-off period generally applies and ends 14 days after delivery, subject to the exceptions and conditions set out by ACM ConsuWijzer. Don’t assume the same consumer rights apply to a business purchase.

Can I use personal data in a local test database?

A local test database isn’t automatically exempt from privacy rules. The Dutch Data Protection Authority defines the processing of personal data broadly and stresses that organisations must prevent unauthorised access. The obligations that apply to your processing depend on the specific data and workflow; this doesn’t amount to general permission to copy production data.